library(tidyverse)
── Attaching core tidyverse packages ───────────────────────────────────────────────────────────────────────────────────────────────────────────────────── tidyverse 2.0.0 ──
✔ dplyr     1.1.4     ✔ readr     2.1.5
✔ forcats   1.0.0     ✔ stringr   1.5.1
✔ ggplot2   3.5.1     ✔ tibble    3.2.1
✔ lubridate 1.9.4     ✔ tidyr     1.3.1
✔ purrr     1.0.4     ── Conflicts ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()
ℹ Use the ]8;;http://conflicted.r-lib.org/conflicted package]8;; to force all conflicts to become errors
library(ggplot2)
library(dplyr)
library(lubridate)
library(corrr)
library(haven)
library(lme4) 
Loading required package: Matrix

Attaching package: ‘Matrix’

The following objects are masked from ‘package:tidyr’:

    expand, pack, unpack
library(broom.mixed) 
library(ggrepel)
library(ggpubr)
library(ggpmisc)
Loading required package: ggpp
Registered S3 methods overwritten by 'ggpp':
  method                  from   
  heightDetails.titleGrob ggplot2
  widthDetails.titleGrob  ggplot2

Attaching package: ‘ggpp’

The following objects are masked from ‘package:ggpubr’:

    as_npc, as_npcx, as_npcy

The following object is masked from ‘package:ggplot2’:

    annotate

Read in data file


firms <- read_dta('../data/firmquarter_2022q1.dta')
firms 
NA

Find entries whose COVID Net Sentiment isn’t 0

NonZero_Firms <- firms |> 
  filter(`Covid_Net_Sentiment` != 0) |> 
  filter(hqcountrycode=='US') |> 
  mutate(Day_of_EarningsCall=dmy(date_earningscall)) 

NonZero_Firms 

Find firms (and their earnings calls) the largest Deltas in their Net COVID Sentiments over time.


Min_Max_Net_COVID_Sentiments <- NonZero_Firms |> 
  group_by(company_name) |> 
  mutate(Min_Net_COVID_Sentiment=min(Covid_Net_Sentiment)) |> 
  mutate(Max_Net_COVID_Sentiment=max(Covid_Net_Sentiment)) |> 
  mutate(Delta_Net_COVID_Sentiment=Max_Net_COVID_Sentiment - Min_Net_COVID_Sentiment) |> 
  arrange(desc(Delta_Net_COVID_Sentiment))
#  arrange(desc(ticker)) |> 
#    arrange(Day_of_EarningsCall) 

Min_Max_Net_COVID_Sentiments  
NA

Find top firms with the largest Deltas in their Net COVID Sentiments over time.


# Top_Firms <- Min_Max_Net_COVID_Sentiments  |> 
#                   distinct(company_name)  
# Top_Firms

# write_csv(Top_Firms, '../data/Top_Firms.csv')

# Dates_Min_Max_Net_COVID_Sentiments <- Min_Max_Net_COVID_Sentiments |> 
#           group_by(company_name) |> 
#           filter(Covid_Net_Sentiment==Min_Net_COVID_Sentiment | Covid_Net_Sentiment==Max_Net_COVID_Sentiment) |> 
#           arrange(desc(Delta_Net_COVID_Sentiment))
# 
# Dates_Min_Max_Net_COVID_Sentiments


# write_csv(Dates_Min_Max_Net_COVID_Sentiments, '../data/Dates_Min_Max_Net_COVID_Sentiments.csv')

Find unique ticker symbols:

# Tickers <- Dates_Min_Max_Net_COVID_Sentiments |> 
#   group_by(company_name) |> 
#   distinct(ticker)
# US_Tickers <- read_csv('../data/DescendingUSTickers_Extended.csv') 
# 
# US_Tickers <- US_Tickers |> 
#                   distinct(ticker)

# write_csv(US_Tickers, '../data/US_Tickers.csv')

Insert industry info via join:


# Industries <- read_csv('../data/CompanyName_Ticker_Industry.csv')
# Industries

# Industries <- Industries |> 
#                 select(-ticker)
# Industries

# Net_COVID_Sentiments_Industries <- Min_Max_Net_COVID_Sentiments |> 
#     inner_join(Industries, by=join_by(company_name))
# 
# Net_COVID_Sentiments_Industries

Exporting data for fetching of share price data: Arranging tickers by descending order in order to place the entries without tickers at the end


# SharePrice_Write_CSV_Prep <- Net_COVID_Sentiments_Industries |>
#   arrange(desc(ticker)) |> 
#   arrange(desc(Industry))
# 
# write_csv(SharePrice_Write_CSV_Prep, "../data/Descending_Ticker_Industry.csv")
Closing_Share_Price_Across_Time_AllYears <- read_csv('../data/Descending_Ticker_Industry_SharePrice.csv')
Warning: One or more parsing issues, call `problems()` on your data frame for details, e.g.:
  dat <- vroom(...)
  problems(dat)Rows: 16440 Columns: 46── Column specification ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
Delimiter: ","
chr   (6): company_name, hqcountrycode, isin, cusip, ticker, Industry
dbl  (32): gvkey, date, PRisk, NPRisk, Risk, PSentiment, NPSentiment, Sentiment, PRiskT_economic, PRiskT_environment, PRiskT_trade, PRiskT_institutions, PRiskT_health, P...
lgl   (5): Brexit_Exposure, Brexit_Neg_Sentiment, Brexit_Pos_Sentiment, Brexit_Net_Sentiment, Brexit_Risk
date  (3): Date_Before_EarningsCall, Day_of_EarningsCall, DayAfter_EarningsCall
ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
Closing_Share_Price_Across_Time  <- Closing_Share_Price_Across_Time_AllYears |> filter(Day_of_EarningsCall > 2019-12-31)
Closing_Share_Price_Across_Time
# Closing_Share_Price_Across_Time_dates <- Closing_Share_Price_Across_Time |> mutate(date_earningscall=dmy(date_earningscall)) 
# Closing_Share_Price_Across_Time_dates

Examines Net COVID Sentiment across industries over time:

Side note: Advertising Agencies is the reference Industry


lm(log(Covid_Net_Sentiment) ~ c(Industry) + Day_of_EarningsCall + Covid_Exposure, data=Closing_Share_Price_Across_Time) |> 
  summary()
Warning: NaNs produced

Call:
lm(formula = log(Covid_Net_Sentiment) ~ c(Industry) + Day_of_EarningsCall + 
    Covid_Exposure, data = Closing_Share_Price_Across_Time)

Residuals:
    Min      1Q  Median      3Q     Max 
-5.2551 -0.4491 -0.0324  0.4203  2.1982 

Coefficients:
                                                      Estimate Std. Error t value Pr(>|t|)    
(Intercept)                                         -3.720e+00  7.978e-01  -4.662 3.22e-06 ***
c(Industry)Aerospace & Defense                      -1.844e-01  1.478e-01  -1.248  0.21226    
c(Industry)Agricultural Inputs                       5.464e-02  2.290e-01   0.239  0.81143    
c(Industry)Airlines                                 -3.516e-01  1.878e-01  -1.872  0.06130 .  
c(Industry)Airports & Air Services                   2.525e-02  6.327e-01   0.040  0.96816    
c(Industry)Aluminum                                 -5.822e-01  3.323e-01  -1.752  0.07989 .  
c(Industry)Apparel Manufacturing                    -1.580e-01  1.610e-01  -0.981  0.32649    
c(Industry)Apparel Retail                            4.708e-02  1.576e-01   0.299  0.76524    
c(Industry)Asset Management                         -7.489e-02  1.328e-01  -0.564  0.57288    
c(Industry)Auto & Truck Dealerships                 -2.968e-01  1.677e-01  -1.770  0.07683 .  
c(Industry)Auto Manufacturers                       -6.908e-02  2.628e-01  -0.263  0.79271    
c(Industry)Auto Parts                               -1.138e-01  1.568e-01  -0.726  0.46788    
c(Industry)Banks - Diversified                      -9.141e-01  3.018e-01  -3.028  0.00247 ** 
c(Industry)Banks - Regional                         -1.134e-01  1.279e-01  -0.886  0.37556    
c(Industry)Beverages - Brewers                      -5.513e-01  3.323e-01  -1.659  0.09718 .  
c(Industry)Beverages - Non-Alcoholic                 1.582e-01  2.145e-01   0.737  0.46096    
c(Industry)Beverages - Wineries & Distilleries      -1.633e-01  3.019e-01  -0.541  0.58848    
c(Industry)Biotechnology                            -4.683e-02  1.229e-01  -0.381  0.70311    
c(Industry)Broadcasting                             -1.123e-01  1.648e-01  -0.682  0.49552    
c(Industry)Building Materials                       -3.819e-01  3.323e-01  -1.149  0.25057    
c(Industry)Building Products & Equipment            -2.146e-01  1.503e-01  -1.427  0.15362    
c(Industry)Business Equipment & Supplies             2.085e-01  3.777e-01   0.552  0.58091    
c(Industry)Capital Markets                          -1.678e-01  1.992e-01  -0.842  0.39960    
c(Industry)Chemicals                                -7.354e-02  2.087e-01  -0.352  0.72462    
c(Industry)Coking Coal                              -2.407e-01  2.493e-01  -0.966  0.33423    
c(Industry)Communication Equipment                  -2.010e-01  1.440e-01  -1.395  0.16302    
c(Industry)Computer Hardware                        -1.297e-01  1.510e-01  -0.859  0.39045    
c(Industry)Confectioners                            -1.911e-01  2.383e-01  -0.802  0.42253    
c(Industry)Conglomerates                            -1.934e-02  1.771e-01  -0.109  0.91306    
c(Industry)Consulting Services                      -2.477e-01  1.729e-01  -1.432  0.15217    
c(Industry)Consumer Electronics                     -2.601e-01  2.145e-01  -1.212  0.22550    
c(Industry)Copper                                   -3.320e-01  3.323e-01  -0.999  0.31777    
c(Industry)Credit Services                          -4.845e-01  1.517e-01  -3.193  0.00142 ** 
c(Industry)Department Stores                        -1.052e-01  2.493e-01  -0.422  0.67303    
c(Industry)Diagnostics & Research                   -2.404e-01  1.294e-01  -1.857  0.06334 .  
c(Industry)Discount Stores                          -3.574e-01  1.634e-01  -2.187  0.02876 *  
c(Industry)Drug Manufacturers - General             -3.715e-01  1.543e-01  -2.408  0.01608 *  
c(Industry)Drug Manufacturers - Specialty & Generic -6.394e-02  1.349e-01  -0.474  0.63554    
c(Industry)Education & Training Services            -6.610e-02  1.662e-01  -0.398  0.69077    
c(Industry)Electrical Equipment & Parts             -3.071e-01  1.695e-01  -1.812  0.07000 .  
c(Industry)Electronic Components                    -1.872e-01  1.557e-01  -1.202  0.22935    
c(Industry)Electronic Gaming & Multimedia           -5.728e-01  2.797e-01  -2.048  0.04066 *  
c(Industry)Electronics & Computer Distribution      -2.321e-02  2.212e-01  -0.105  0.91643    
c(Industry)Engineering & Construction               -2.981e-01  1.431e-01  -2.083  0.03728 *  
c(Industry)Entertainment                            -1.973e-01  1.510e-01  -1.307  0.19131    
c(Industry)Farm & Heavy Construction Machinery      -3.483e-01  1.648e-01  -2.113  0.03464 *  
c(Industry)Farm Products                            -5.697e-02  1.878e-01  -0.303  0.76166    
c(Industry)Financial Conglomerates                   1.498e-03  3.776e-01   0.004  0.99684    
c(Industry)Financial Data & Stock Exchanges         -3.848e-01  2.146e-01  -1.793  0.07306 .  
c(Industry)Food Distribution                        -1.105e-01  1.711e-01  -0.646  0.51834    
c(Industry)Footwear & Accessories                   -8.716e-02  1.948e-01  -0.447  0.65462    
c(Industry)Furnishings, Fixtures & Appliances       -1.136e-01  1.587e-01  -0.716  0.47403    
c(Industry)Gambling                                 -6.023e-02  1.913e-01  -0.315  0.75291    
c(Industry)Gold                                     -2.335e-01  2.036e-01  -1.147  0.25132    
c(Industry)Grocery Stores                           -1.107e-01  1.878e-01  -0.589  0.55577    
c(Industry)Health Information Services              -2.715e-01  1.423e-01  -1.908  0.05644 .  
c(Industry)Healthcare Plans                         -3.956e-01  1.799e-01  -2.199  0.02796 *  
c(Industry)Home Improvement Retail                  -3.115e-01  2.213e-01  -1.408  0.15928    
c(Industry)Household & Personal Products            -7.899e-02  1.576e-01  -0.501  0.61636    
c(Industry)Industrial Distribution                  -1.883e-01  1.634e-01  -1.153  0.24912    
c(Industry)Information Technology Services          -1.803e-01  1.431e-01  -1.260  0.20775    
c(Industry)Infrastructure Operations                 2.791e-02  6.326e-01   0.044  0.96482    
c(Industry)Insurance - Diversified                  -1.599e-01  3.019e-01  -0.530  0.59644    
c(Industry)Insurance - Life                         -2.305e-01  2.147e-01  -1.074  0.28307    
c(Industry)Insurance - Property & Casualty          -1.343e-01  1.621e-01  -0.829  0.40736    
c(Industry)Insurance - Specialty                    -9.936e-02  2.087e-01  -0.476  0.63397    
c(Industry)Insurance Brokers                        -3.579e-01  2.146e-01  -1.668  0.09536 .  
c(Industry)Integrated Freight & Logistics           -3.213e-01  1.772e-01  -1.814  0.06982 .  
c(Industry)Internet Content & Information           -2.252e-01  1.517e-01  -1.485  0.13770    
c(Industry)Internet Retail                          -3.842e-01  1.795e-01  -2.140  0.03238 *  
c(Industry)Leisure                                  -2.487e-01  1.711e-01  -1.454  0.14608    
c(Industry)Lodging                                   7.484e-02  2.382e-01   0.314  0.75340    
c(Industry)Lumber & Wood Production                  1.205e-01  2.797e-01   0.431  0.66671    
c(Industry)Luxury Goods                             -2.739e-02  2.145e-01  -0.128  0.89840    
c(Industry)Marine Shipping                           1.083e-02  3.018e-01   0.036  0.97138    
c(Industry)Medical Care Facilities                  -3.421e-01  1.433e-01  -2.387  0.01704 *  
c(Industry)Medical Devices                          -2.199e-01  1.255e-01  -1.752  0.07979 .  
c(Industry)Medical Distribution                     -3.187e-01  1.797e-01  -1.773  0.07623 .  
c(Industry)Medical Instruments & Supplies           -2.165e-01  1.335e-01  -1.622  0.10484    
c(Industry)Metal Fabrication                        -3.939e-02  2.213e-01  -0.178  0.85875    
c(Industry)Mortgage Finance                         -2.293e-01  2.493e-01  -0.920  0.35783    
c(Industry)Oil & Gas Drilling                        3.605e-01  4.550e-01   0.792  0.42826    
c(Industry)Oil & Gas E&P                            -7.865e-02  1.623e-01  -0.485  0.62795    
c(Industry)Oil & Gas Equipment & Services           -1.221e-01  1.550e-01  -0.788  0.43063    
c(Industry)Oil & Gas Integrated                     -3.529e-01  2.798e-01  -1.261  0.20721    
c(Industry)Oil & Gas Midstream                      -2.302e-02  1.879e-01  -0.123  0.90246    
c(Industry)Oil & Gas Refining & Marketing           -1.243e-01  1.912e-01  -0.650  0.51580    
c(Industry)Other Industrial Metals & Mining         -4.901e-01  4.551e-01  -1.077  0.28158    
c(Industry)Other Precious Metals & Mining            3.086e-01  4.550e-01   0.678  0.49776    
c(Industry)Packaged Foods                           -3.091e-02  1.357e-01  -0.228  0.81982    
c(Industry)Packaging & Containers                   -2.579e-01  1.587e-01  -1.625  0.10420    
c(Industry)Personal Services                        -2.345e-01  1.948e-01  -1.204  0.22870    
c(Industry)Pharmaceutical Retailers                 -2.055e-01  3.018e-01  -0.681  0.49598    
c(Industry)Pollution & Treatment Controls           -5.747e-02  2.493e-01  -0.231  0.81765    
c(Industry)Publishing                               -1.004e-01  2.796e-01  -0.359  0.71966    
c(Industry)Railroads                                -5.136e-01  2.145e-01  -2.394  0.01670 *  
c(Industry)Real Estate - Development                -7.443e-02  4.551e-01  -0.164  0.87009    
c(Industry)Real Estate - Diversified                 3.764e-01  3.776e-01   0.997  0.31896    
c(Industry)Real Estate Services                     -3.016e-01  1.772e-01  -1.702  0.08889 .  
c(Industry)Recreational Vehicles                    -3.308e-01  1.950e-01  -1.697  0.08984 .  
c(Industry)REIT - Diversified                        1.183e-01  1.879e-01   0.630  0.52903    
c(Industry)REIT - Healthcare Facilities             -2.696e-01  1.600e-01  -1.685  0.09201 .  
c(Industry)REIT - Hotel & Motel                     -1.337e-01  1.567e-01  -0.853  0.39362    
c(Industry)REIT - Industrial                        -2.049e-01  1.850e-01  -1.108  0.26804    
c(Industry)REIT - Mortgage                           2.111e-02  1.439e-01   0.147  0.88341    
c(Industry)REIT - Office                            -2.825e-01  1.729e-01  -1.634  0.10235    
c(Industry)REIT - Residential                       -2.851e-01  1.587e-01  -1.796  0.07250 .  
c(Industry)REIT - Retail                            -2.542e-01  1.540e-01  -1.651  0.09884 .  
c(Industry)REIT - Specialty                          4.739e-02  1.677e-01   0.283  0.77751    
c(Industry)Rental & Leasing Services                -3.040e-01  1.848e-01  -1.646  0.09993 .  
c(Industry)Residential Construction                 -1.317e-01  2.212e-01  -0.595  0.55181    
c(Industry)Resorts & Casinos                        -3.121e-02  1.647e-01  -0.189  0.84976    
c(Industry)Restaurants                              -1.733e-01  1.387e-01  -1.249  0.21164    
c(Industry)Scientific & Technical Instruments       -4.102e-02  1.634e-01  -0.251  0.80172    
c(Industry)Security & Protection Services           -2.881e-01  2.145e-01  -1.343  0.17937    
c(Industry)Semiconductor Equipment & Materials      -6.938e-02  1.491e-01  -0.465  0.64178    
c(Industry)Semiconductors                           -1.892e-01  1.403e-01  -1.348  0.17765    
c(Industry)Software - Application                   -2.114e-01  1.237e-01  -1.709  0.08756 .  
c(Industry)Software - Infrastructure                -2.256e-01  1.286e-01  -1.755  0.07941 .  
c(Industry)Solar                                    -2.360e-01  2.628e-01  -0.898  0.36930    
c(Industry)Specialty Business Services              -2.033e-01  1.496e-01  -1.359  0.17436    
c(Industry)Specialty Chemicals                      -2.256e-01  1.377e-01  -1.638  0.10146    
c(Industry)Specialty Industrial Machinery           -1.614e-01  1.382e-01  -1.167  0.24314    
c(Industry)Specialty Retail                         -4.057e-01  1.549e-01  -2.619  0.00886 ** 
c(Industry)Staffing & Employment Services            1.772e-01  1.795e-01   0.987  0.32362    
c(Industry)Steel                                    -6.923e-02  2.036e-01  -0.340  0.73389    
c(Industry)Telecom Services                         -2.345e-01  1.622e-01  -1.446  0.14822    
c(Industry)Textile Manufacturing                     1.874e-01  2.627e-01   0.713  0.47569    
c(Industry)Thermal Coal                              3.058e-01  2.290e-01   1.335  0.18192    
c(Industry)Tobacco                                  -1.875e-01  2.383e-01  -0.787  0.43140    
c(Industry)Tools & Accessories                      -1.099e-01  1.848e-01  -0.595  0.55203    
c(Industry)Travel Services                          -7.698e-02  1.647e-01  -0.467  0.64028    
c(Industry)Trucking                                 -5.969e-01  2.493e-01  -2.395  0.01668 *  
c(Industry)Uranium                                   9.527e-01  4.551e-01   2.093  0.03637 *  
c(Industry)Utilities - Diversified                   2.181e-01  3.019e-01   0.722  0.47003    
c(Industry)Utilities - Independent Power Producers  -4.532e-01  4.550e-01  -0.996  0.31936    
c(Industry)Utilities - Regulated Electric           -2.860e-01  1.453e-01  -1.969  0.04905 *  
c(Industry)Utilities - Regulated Gas                 1.287e-01  1.990e-01   0.647  0.51789    
c(Industry)Utilities - Regulated Water               1.622e-01  2.797e-01   0.580  0.56199    
c(Industry)Utilities - Renewable                    -3.092e-01  6.327e-01  -0.489  0.62503    
c(Industry)Waste Management                         -1.228e-01  1.750e-01  -0.702  0.48287    
Day_of_EarningsCall                                  1.176e-04  4.192e-05   2.805  0.00506 ** 
Covid_Exposure                                       2.712e-01  8.630e-03  31.431  < 2e-16 ***
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.6216 on 4346 degrees of freedom
  (11951 observations deleted due to missingness)
Multiple R-squared:  0.2559,    Adjusted R-squared:  0.2316 
F-statistic: 10.53 on 142 and 4346 DF,  p-value: < 2.2e-16

Examines Positive COVID Sentiment across industries over time:


lm(Covid_Pos_Sentiment ~ c(Industry) + Day_of_EarningsCall + Covid_Exposure, data=Closing_Share_Price_Across_Time) |> 
  summary()

Call:
lm(formula = Covid_Pos_Sentiment ~ c(Industry) + Day_of_EarningsCall + 
    Covid_Exposure, data = Closing_Share_Price_Across_Time)

Residuals:
    Min      1Q  Median      3Q     Max 
-2.0039 -0.1673 -0.0424  0.1273  3.4016 

Coefficients:
                                                      Estimate Std. Error t value Pr(>|t|)    
(Intercept)                                         -1.831e+00  2.121e-01  -8.634  < 2e-16 ***
c(Industry)Aerospace & Defense                      -1.218e-02  4.289e-02  -0.284  0.77641    
c(Industry)Agricultural Inputs                      -9.414e-03  6.318e-02  -0.149  0.88155    
c(Industry)Airlines                                 -2.914e-02  5.316e-02  -0.548  0.58365    
c(Industry)Airports & Air Services                   1.153e-01  1.898e-01   0.607  0.54366    
c(Industry)Aluminum                                 -1.588e-02  9.327e-02  -0.170  0.86483    
c(Industry)Apparel Manufacturing                     1.120e-01  4.720e-02   2.373  0.01765 *  
c(Industry)Apparel Retail                            2.650e-02  4.442e-02   0.597  0.55082    
c(Industry)Asset Management                          2.325e-02  3.944e-02   0.590  0.55551    
c(Industry)Auto & Truck Dealerships                 -1.932e-02  4.915e-02  -0.393  0.69428    
c(Industry)Auto Manufacturers                        4.867e-02  7.150e-02   0.681  0.49609    
c(Industry)Auto Parts                                4.569e-02  4.363e-02   1.047  0.29500    
c(Industry)Banks - Diversified                      -5.966e-02  7.052e-02  -0.846  0.39761    
c(Industry)Banks - Regional                         -3.610e-02  3.775e-02  -0.956  0.33896    
c(Industry)Beverages - Brewers                      -2.764e-02  8.208e-02  -0.337  0.73634    
c(Industry)Beverages - Non-Alcoholic                 1.497e-01  5.846e-02   2.561  0.01045 *  
c(Industry)Beverages - Wineries & Distilleries       6.802e-02  1.036e-01   0.657  0.51146    
c(Industry)Biotechnology                             5.433e-02  3.720e-02   1.460  0.14419    
c(Industry)Broadcasting                              8.160e-03  5.250e-02   0.155  0.87648    
c(Industry)Building Materials                       -4.446e-02  6.960e-02  -0.639  0.52299    
c(Industry)Building Products & Equipment             3.150e-02  4.491e-02   0.702  0.48298    
c(Industry)Business Equipment & Supplies             7.847e-02  9.986e-02   0.786  0.43197    
c(Industry)Capital Markets                           2.150e-02  5.465e-02   0.393  0.69402    
c(Industry)Chemicals                                 9.906e-02  6.208e-02   1.596  0.11057    
c(Industry)Coking Coal                              -3.515e-02  7.148e-02  -0.492  0.62295    
c(Industry)Communication Equipment                  -1.161e-02  4.240e-02  -0.274  0.78418    
c(Industry)Computer Hardware                         6.988e-02  4.827e-02   1.448  0.14771    
c(Industry)Confectioners                             4.267e-01  9.058e-02   4.710 2.50e-06 ***
c(Industry)Conglomerates                            -3.128e-03  5.080e-02  -0.062  0.95090    
c(Industry)Consulting Services                       5.275e-02  5.461e-02   0.966  0.33407    
c(Industry)Consumer Electronics                     -1.306e-02  6.375e-02  -0.205  0.83767    
c(Industry)Copper                                   -4.191e-02  8.592e-02  -0.488  0.62574    
c(Industry)Credit Services                          -1.690e-02  4.613e-02  -0.366  0.71414    
c(Industry)Department Stores                        -8.487e-03  8.393e-02  -0.101  0.91946    
c(Industry)Diagnostics & Research                    1.248e-02  4.101e-02   0.304  0.76084    
c(Industry)Discount Stores                           2.572e-02  5.636e-02   0.456  0.64814    
c(Industry)Drug Manufacturers - General              1.757e-01  5.396e-02   3.256  0.00113 ** 
c(Industry)Drug Manufacturers - Specialty & Generic  9.678e-02  4.151e-02   2.332  0.01973 *  
c(Industry)Education & Training Services             1.926e-03  5.229e-02   0.037  0.97062    
c(Industry)Electrical Equipment & Parts              2.943e-02  4.827e-02   0.610  0.54204    
c(Industry)Electronic Components                    -9.960e-03  4.293e-02  -0.232  0.81655    
c(Industry)Electronic Gaming & Multimedia            1.040e-02  1.081e-01   0.096  0.92334    
c(Industry)Electronics & Computer Distribution      -1.081e-02  6.638e-02  -0.163  0.87068    
c(Industry)Engineering & Construction                3.539e-02  4.339e-02   0.816  0.41478    
c(Industry)Entertainment                             5.734e-02  4.629e-02   1.239  0.21543    
c(Industry)Farm & Heavy Construction Machinery       1.310e-02  4.682e-02   0.280  0.77954    
c(Industry)Farm Products                             3.375e-02  5.885e-02   0.573  0.56632    
c(Industry)Financial Conglomerates                   6.864e-02  9.327e-02   0.736  0.46178    
c(Industry)Financial Data & Stock Exchanges         -5.213e-05  5.811e-02  -0.001  0.99928    
c(Industry)Food Distribution                         6.878e-02  5.701e-02   1.206  0.22765    
c(Industry)Footwear & Accessories                   -1.548e-02  5.080e-02  -0.305  0.76054    
c(Industry)Furnishings, Fixtures & Appliances        5.946e-02  4.596e-02   1.294  0.19585    
c(Industry)Gambling                                  3.194e-02  6.207e-02   0.515  0.60684    
c(Industry)Gold                                      2.454e-02  6.872e-02   0.357  0.72105    
c(Industry)Grocery Stores                           -9.133e-03  6.568e-02  -0.139  0.88940    
c(Industry)Health Information Services              -3.887e-02  4.461e-02  -0.871  0.38361    
c(Industry)Healthcare Plans                         -2.383e-01  5.627e-02  -4.234 2.31e-05 ***
c(Industry)Home Improvement Retail                  -1.904e-03  6.790e-02  -0.028  0.97763    
c(Industry)Household & Personal Products             1.069e-01  4.710e-02   2.271  0.02319 *  
c(Industry)Industrial Distribution                   3.620e-02  4.889e-02   0.740  0.45905    
c(Industry)Information Technology Services           1.088e-02  4.339e-02   0.251  0.80206    
c(Industry)Infrastructure Operations                 7.943e-03  1.487e-01   0.053  0.95741    
c(Industry)Insurance - Diversified                   4.604e-02  8.039e-02   0.573  0.56680    
c(Industry)Insurance - Life                         -4.618e-02  5.216e-02  -0.885  0.37603    
c(Industry)Insurance - Property & Casualty          -1.034e-02  4.331e-02  -0.239  0.81128    
c(Industry)Insurance - Reinsurance                  -4.780e-01  1.205e-01  -3.968 7.29e-05 ***
c(Industry)Insurance - Specialty                    -5.497e-03  5.410e-02  -0.102  0.91907    
c(Industry)Insurance Brokers                         2.680e-02  6.155e-02   0.435  0.66323    
c(Industry)Integrated Freight & Logistics           -2.282e-02  5.361e-02  -0.426  0.67035    
c(Industry)Internet Content & Information            2.657e-02  4.827e-02   0.550  0.58204    
c(Industry)Internet Retail                           1.364e-02  5.701e-02   0.239  0.81095    
c(Industry)Leisure                                   3.511e-02  5.016e-02   0.700  0.48393    
c(Industry)Lodging                                  -5.947e-02  6.155e-02  -0.966  0.33401    
c(Industry)Lumber & Wood Production                  9.454e-02  8.392e-02   1.127  0.25992    
c(Industry)Luxury Goods                              1.940e-01  8.039e-02   2.413  0.01582 *  
c(Industry)Marine Shipping                          -9.641e-02  7.361e-02  -1.310  0.19031    
c(Industry)Medical Care Facilities                  -4.494e-02  4.306e-02  -1.044  0.29661    
c(Industry)Medical Devices                          -5.358e-03  3.810e-02  -0.141  0.88815    
c(Industry)Medical Distribution                     -3.724e-02  5.813e-02  -0.641  0.52169    
c(Industry)Medical Instruments & Supplies            2.935e-02  4.139e-02   0.709  0.47826    
c(Industry)Metal Fabrication                        -1.449e-02  5.229e-02  -0.277  0.78170    
c(Industry)Mortgage Finance                         -6.771e-02  6.436e-02  -1.052  0.29284    
c(Industry)Oil & Gas Drilling                        1.457e-02  9.971e-02   0.146  0.88380    
c(Industry)Oil & Gas E&P                             4.313e-02  4.651e-02   0.927  0.35372    
c(Industry)Oil & Gas Equipment & Services            1.407e-02  4.336e-02   0.325  0.74553    
c(Industry)Oil & Gas Integrated                     -2.503e-02  9.058e-02  -0.276  0.78230    
c(Industry)Oil & Gas Midstream                      -7.130e-02  5.032e-02  -1.417  0.15658    
c(Industry)Oil & Gas Refining & Marketing            1.370e-02  5.361e-02   0.255  0.79836    
c(Industry)Other Industrial Metals & Mining         -2.915e-02  9.971e-02  -0.292  0.77002    
c(Industry)Other Precious Metals & Mining           -4.529e-03  1.133e-01  -0.040  0.96813    
c(Industry)Packaged Foods                            4.906e-02  4.189e-02   1.171  0.24154    
c(Industry)Packaging & Containers                    2.644e-02  4.828e-02   0.548  0.58394    
c(Industry)Paper & Paper Products                   -1.706e-01  1.365e-01  -1.249  0.21161    
c(Industry)Personal Services                         3.245e-03  5.771e-02   0.056  0.95517    
c(Industry)Pharmaceutical Retailers                 -7.776e-02  9.976e-02  -0.780  0.43569    
c(Industry)Pollution & Treatment Controls            5.499e-03  7.251e-02   0.076  0.93955    
c(Industry)Publishing                                2.093e-03  6.959e-02   0.030  0.97600    
c(Industry)Railroads                                 1.497e-02  5.637e-02   0.266  0.79061    
c(Industry)Real Estate - Development                -2.069e-02  1.081e-01  -0.191  0.84822    
c(Industry)Real Estate - Diversified                -3.036e-02  1.365e-01  -0.222  0.82403    
c(Industry)Real Estate Services                     -1.626e-02  5.339e-02  -0.305  0.76071    
c(Industry)Recreational Vehicles                     1.782e-02  5.969e-02   0.298  0.76535    
c(Industry)REIT - Diversified                        3.186e-02  5.702e-02   0.559  0.57630    
c(Industry)REIT - Healthcare Facilities              4.088e-02  5.101e-02   0.801  0.42287    
c(Industry)REIT - Hotel & Motel                      4.519e-02  4.865e-02   0.929  0.35305    
c(Industry)REIT - Industrial                         2.719e-02  5.703e-02   0.477  0.63358    
c(Industry)REIT - Mortgage                           2.799e-02  4.297e-02   0.651  0.51485    
c(Industry)REIT - Office                             1.400e-02  4.971e-02   0.282  0.77828    
c(Industry)REIT - Residential                        1.704e-02  4.889e-02   0.348  0.72752    
c(Industry)REIT - Retail                             1.326e-02  4.750e-02   0.279  0.78018    
c(Industry)REIT - Specialty                          1.936e-02  4.863e-02   0.398  0.69065    
c(Industry)Rental & Leasing Services                -3.425e-02  5.209e-02  -0.658  0.51081    
c(Industry)Residential Construction                  3.341e-03  5.001e-02   0.067  0.94674    
c(Industry)Resorts & Casinos                         2.341e-02  5.064e-02   0.462  0.64383    
c(Industry)Restaurants                               3.161e-02  4.244e-02   0.745  0.45633    
c(Industry)Scientific & Technical Instruments       -7.802e-04  4.566e-02  -0.017  0.98637    
c(Industry)Security & Protection Services            9.510e-03  5.575e-02   0.171  0.86455    
c(Industry)Semiconductor Equipment & Materials       7.747e-03  4.622e-02   0.168  0.86687    
c(Industry)Semiconductors                            5.868e-02  4.282e-02   1.370  0.17057    
c(Industry)Software - Application                    6.147e-02  3.807e-02   1.615  0.10635    
c(Industry)Software - Infrastructure                 2.329e-02  3.953e-02   0.589  0.55581    
c(Industry)Solar                                     4.163e-02  7.253e-02   0.574  0.56602    
c(Industry)Specialty Business Services              -1.113e-02  4.655e-02  -0.239  0.81101    
c(Industry)Specialty Chemicals                       7.104e-02  4.154e-02   1.710  0.08727 .  
c(Industry)Specialty Industrial Machinery            3.637e-02  4.023e-02   0.904  0.36603    
c(Industry)Specialty Retail                         -4.160e-02  4.340e-02  -0.959  0.33774    
c(Industry)Staffing & Employment Services            1.388e-02  5.016e-02   0.277  0.78198    
c(Industry)Steel                                     2.402e-02  6.107e-02   0.393  0.69404    
c(Industry)Telecom Services                         -4.842e-02  4.804e-02  -1.008  0.31356    
c(Industry)Textile Manufacturing                     1.210e-01  7.362e-02   1.644  0.10016    
c(Industry)Thermal Coal                              5.487e-02  6.567e-02   0.836  0.40344    
c(Industry)Tobacco                                  -4.867e-02  6.106e-02  -0.797  0.42542    
c(Industry)Tools & Accessories                      -7.272e-03  5.544e-02  -0.131  0.89565    
c(Industry)Travel Services                           4.934e-02  5.574e-02   0.885  0.37610    
c(Industry)Trucking                                 -1.873e-02  6.502e-02  -0.288  0.77333    
c(Industry)Uranium                                   1.775e-01  1.271e-01   1.397  0.16254    
c(Industry)Utilities - Diversified                  -1.578e-01  6.796e-02  -2.322  0.02023 *  
c(Industry)Utilities - Independent Power Producers  -4.111e-02  1.195e-01  -0.344  0.73091    
c(Industry)Utilities - Regulated Electric           -2.534e-02  4.368e-02  -0.580  0.56182    
c(Industry)Utilities - Regulated Gas                -1.162e-01  5.704e-02  -2.037  0.04170 *  
c(Industry)Utilities - Regulated Water              -9.825e-02  6.959e-02  -1.412  0.15804    
c(Industry)Utilities - Renewable                    -2.168e-02  1.133e-01  -0.191  0.84826    
c(Industry)Waste Management                          1.150e-01  5.808e-02   1.980  0.04774 *  
Day_of_EarningsCall                                  9.787e-05  1.116e-05   8.770  < 2e-16 ***
Covid_Exposure                                       2.624e-01  2.651e-03  98.987  < 2e-16 ***
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.3231 on 13005 degrees of freedom
  (3290 observations deleted due to missingness)
Multiple R-squared:  0.4923,    Adjusted R-squared:  0.4866 
F-statistic: 87.56 on 144 and 13005 DF,  p-value: < 2.2e-16

lm(Covid_Neg_Sentiment ~ c(Industry) + Day_of_EarningsCall + Covid_Exposure + PRiskT_health, data=Closing_Share_Price_Across_Time) |> 
  summary()

Call:
lm(formula = Covid_Neg_Sentiment ~ c(Industry) + Day_of_EarningsCall + 
    Covid_Exposure + PRiskT_health, data = Closing_Share_Price_Across_Time)

Residuals:
    Min      1Q  Median      3Q     Max 
-2.4738 -0.2176 -0.0387  0.1713  5.1861 

Coefficients:
                                                      Estimate Std. Error t value Pr(>|t|)    
(Intercept)                                          1.676e+00  2.780e-01   6.027 1.71e-09 ***
c(Industry)Aerospace & Defense                       6.841e-02  5.607e-02   1.220 0.222421    
c(Industry)Agricultural Inputs                       5.721e-03  8.260e-02   0.069 0.944779    
c(Industry)Airlines                                 -1.314e-02  6.950e-02  -0.189 0.850080    
c(Industry)Airports & Air Services                   1.911e-03  2.482e-01   0.008 0.993857    
c(Industry)Aluminum                                  3.150e-01  1.219e-01   2.584 0.009791 ** 
c(Industry)Apparel Manufacturing                     6.190e-02  6.171e-02   1.003 0.315895    
c(Industry)Apparel Retail                            6.605e-02  5.807e-02   1.137 0.255403    
c(Industry)Asset Management                          7.501e-02  5.157e-02   1.455 0.145768    
c(Industry)Auto & Truck Dealerships                  3.269e-02  6.426e-02   0.509 0.610993    
c(Industry)Auto Manufacturers                        7.705e-02  9.348e-02   0.824 0.409799    
c(Industry)Auto Parts                                2.359e-01  5.704e-02   4.136 3.56e-05 ***
c(Industry)Banks - Diversified                      -4.399e-02  9.221e-02  -0.477 0.633317    
c(Industry)Banks - Regional                          3.635e-02  4.935e-02   0.736 0.461464    
c(Industry)Beverages - Brewers                       4.497e-02  1.073e-01   0.419 0.675157    
c(Industry)Beverages - Non-Alcoholic                 1.192e-01  7.644e-02   1.560 0.118848    
c(Industry)Beverages - Wineries & Distilleries       5.583e-02  1.354e-01   0.412 0.680224    
c(Industry)Biotechnology                            -5.908e-02  4.864e-02  -1.215 0.224488    
c(Industry)Broadcasting                              4.561e-02  6.863e-02   0.665 0.506332    
c(Industry)Building Materials                        5.174e-02  9.099e-02   0.569 0.569627    
c(Industry)Building Products & Equipment             5.318e-02  5.871e-02   0.906 0.365085    
c(Industry)Business Equipment & Supplies             5.324e-02  1.306e-01   0.408 0.683438    
c(Industry)Capital Markets                           6.435e-02  7.145e-02   0.901 0.367769    
c(Industry)Chemicals                                 2.576e-01  8.116e-02   3.175 0.001504 ** 
c(Industry)Coking Coal                               8.783e-02  9.345e-02   0.940 0.347310    
c(Industry)Communication Equipment                   5.142e-02  5.544e-02   0.928 0.353652    
c(Industry)Computer Hardware                         3.250e-02  6.311e-02   0.515 0.606545    
c(Industry)Confectioners                             1.328e-02  1.184e-01   0.112 0.910719    
c(Industry)Conglomerates                             2.050e-02  6.642e-02   0.309 0.757552    
c(Industry)Consulting Services                      -6.984e-03  7.141e-02  -0.098 0.922085    
c(Industry)Consumer Electronics                      7.225e-02  8.335e-02   0.867 0.386010    
c(Industry)Copper                                   -1.640e-02  1.123e-01  -0.146 0.883925    
c(Industry)Credit Services                           6.258e-02  6.031e-02   1.038 0.299406    
c(Industry)Department Stores                        -1.529e-01  1.097e-01  -1.393 0.163568    
c(Industry)Diagnostics & Research                   -3.804e-01  5.362e-02  -7.095 1.36e-12 ***
c(Industry)Discount Stores                          -9.151e-02  7.369e-02  -1.242 0.214295    
c(Industry)Drug Manufacturers - General             -1.988e-01  7.058e-02  -2.816 0.004870 ** 
c(Industry)Drug Manufacturers - Specialty & Generic -6.273e-02  5.428e-02  -1.156 0.247872    
c(Industry)Education & Training Services            -2.988e-02  6.836e-02  -0.437 0.662003    
c(Industry)Electrical Equipment & Parts              1.200e-01  6.312e-02   1.902 0.057227 .  
c(Industry)Electronic Components                     2.063e-01  5.613e-02   3.675 0.000238 ***
c(Industry)Electronic Gaming & Multimedia           -1.262e-01  1.413e-01  -0.893 0.371837    
c(Industry)Electronics & Computer Distribution       5.834e-02  8.678e-02   0.672 0.501424    
c(Industry)Engineering & Construction                8.248e-02  5.673e-02   1.454 0.146033    
c(Industry)Entertainment                             1.579e-01  6.052e-02   2.608 0.009105 ** 
c(Industry)Farm & Heavy Construction Machinery       1.556e-01  6.121e-02   2.542 0.011027 *  
c(Industry)Farm Products                            -1.148e-02  7.694e-02  -0.149 0.881414    
c(Industry)Financial Conglomerates                   8.773e-02  1.219e-01   0.720 0.471836    
c(Industry)Financial Data & Stock Exchanges         -1.814e-02  7.597e-02  -0.239 0.811325    
c(Industry)Food Distribution                        -5.915e-02  7.453e-02  -0.794 0.427428    
c(Industry)Footwear & Accessories                    6.602e-02  6.642e-02   0.994 0.320265    
c(Industry)Furnishings, Fixtures & Appliances        1.978e-01  6.009e-02   3.292 0.000997 ***
c(Industry)Gambling                                 -6.433e-02  8.115e-02  -0.793 0.427933    
c(Industry)Gold                                     -1.003e-01  8.984e-02  -1.117 0.264123    
c(Industry)Grocery Stores                           -2.184e-01  8.587e-02  -2.544 0.010975 *  
c(Industry)Health Information Services              -1.300e-01  5.833e-02  -2.228 0.025911 *  
c(Industry)Healthcare Plans                         -4.482e-01  7.373e-02  -6.079 1.24e-09 ***
c(Industry)Home Improvement Retail                   1.676e-01  8.877e-02   1.888 0.059059 .  
c(Industry)Household & Personal Products             1.026e-01  6.158e-02   1.666 0.095805 .  
c(Industry)Industrial Distribution                   5.505e-02  6.391e-02   0.861 0.389089    
c(Industry)Information Technology Services          -5.359e-02  5.673e-02  -0.945 0.344918    
c(Industry)Infrastructure Operations                 1.238e-01  1.945e-01   0.637 0.524211    
c(Industry)Insurance - Diversified                   1.832e-01  1.051e-01   1.744 0.081265 .  
c(Industry)Insurance - Life                          4.146e-01  6.820e-02   6.079 1.25e-09 ***
c(Industry)Insurance - Property & Casualty           4.603e-01  5.663e-02   8.128 4.77e-16 ***
c(Industry)Insurance - Reinsurance                   7.452e-01  1.575e-01   4.732 2.25e-06 ***
c(Industry)Insurance - Specialty                     3.791e-01  7.074e-02   5.359 8.52e-08 ***
c(Industry)Insurance Brokers                         1.764e-01  8.052e-02   2.190 0.028521 *  
c(Industry)Integrated Freight & Logistics           -2.131e-02  7.010e-02  -0.304 0.761159    
c(Industry)Internet Content & Information           -8.723e-02  6.311e-02  -1.382 0.166928    
c(Industry)Internet Retail                           1.605e-02  7.454e-02   0.215 0.829481    
c(Industry)Leisure                                   3.043e-02  6.557e-02   0.464 0.642638    
c(Industry)Lodging                                  -6.653e-03  8.048e-02  -0.083 0.934115    
c(Industry)Lumber & Wood Production                  5.976e-02  1.097e-01   0.545 0.585946    
c(Industry)Luxury Goods                             -1.290e-01  1.051e-01  -1.228 0.219638    
c(Industry)Marine Shipping                           1.971e-01  9.624e-02   2.048 0.040585 *  
c(Industry)Medical Care Facilities                  -9.980e-02  5.629e-02  -1.773 0.076289 .  
c(Industry)Medical Devices                          -1.057e-01  4.981e-02  -2.121 0.033901 *  
c(Industry)Medical Distribution                     -2.675e-01  7.600e-02  -3.520 0.000433 ***
c(Industry)Medical Instruments & Supplies           -2.374e-01  5.411e-02  -4.387 1.16e-05 ***
c(Industry)Metal Fabrication                         2.472e-01  6.836e-02   3.616 0.000300 ***
c(Industry)Mortgage Finance                          1.988e-01  8.415e-02   2.362 0.018179 *  
c(Industry)Oil & Gas Drilling                        3.796e-01  1.304e-01   2.912 0.003593 ** 
c(Industry)Oil & Gas E&P                             8.586e-02  6.080e-02   1.412 0.157939    
c(Industry)Oil & Gas Equipment & Services            2.648e-01  5.669e-02   4.671 3.02e-06 ***
c(Industry)Oil & Gas Integrated                      2.340e-02  1.184e-01   0.198 0.843349    
c(Industry)Oil & Gas Midstream                       4.161e-02  6.579e-02   0.632 0.527155    
c(Industry)Oil & Gas Refining & Marketing            1.160e-01  7.009e-02   1.654 0.098058 .  
c(Industry)Other Industrial Metals & Mining          1.422e-01  1.304e-01   1.091 0.275329    
c(Industry)Other Precious Metals & Mining            5.371e-02  1.482e-01   0.362 0.716989    
c(Industry)Packaged Foods                           -2.848e-02  5.477e-02  -0.520 0.603010    
c(Industry)Packaging & Containers                   -2.823e-02  6.312e-02  -0.447 0.654660    
c(Industry)Paper & Paper Products                    1.137e-01  1.785e-01   0.637 0.524106    
c(Industry)Personal Services                         5.035e-02  7.546e-02   0.667 0.504608    
c(Industry)Pharmaceutical Retailers                 -1.121e-03  1.304e-01  -0.009 0.993141    
c(Industry)Pollution & Treatment Controls            7.877e-02  9.480e-02   0.831 0.406035    
c(Industry)Publishing                                3.671e-01  9.098e-02   4.035 5.49e-05 ***
c(Industry)Railroads                                 1.136e-01  7.369e-02   1.542 0.123208    
c(Industry)Real Estate - Development                 1.511e-01  1.413e-01   1.069 0.285123    
c(Industry)Real Estate - Diversified                -1.192e-01  1.785e-01  -0.668 0.504303    
c(Industry)Real Estate Services                      2.131e-02  6.980e-02   0.305 0.760164    
c(Industry)Recreational Vehicles                     9.400e-02  7.804e-02   1.204 0.228429    
c(Industry)REIT - Diversified                       -1.490e-02  7.455e-02  -0.200 0.841544    
c(Industry)REIT - Healthcare Facilities             -1.340e-01  6.673e-02  -2.008 0.044685 *  
c(Industry)REIT - Hotel & Motel                      1.415e-02  6.361e-02   0.222 0.823982    
c(Industry)REIT - Industrial                        -3.520e-02  7.456e-02  -0.472 0.636899    
c(Industry)REIT - Mortgage                           1.117e-01  5.620e-02   1.988 0.046888 *  
c(Industry)REIT - Office                            -1.881e-02  6.499e-02  -0.289 0.772241    
c(Industry)REIT - Residential                       -3.839e-02  6.392e-02  -0.601 0.548152    
c(Industry)REIT - Retail                            -1.327e-02  6.210e-02  -0.214 0.830783    
c(Industry)REIT - Specialty                         -2.085e-03  6.359e-02  -0.033 0.973840    
c(Industry)Rental & Leasing Services                 7.535e-02  6.810e-02   1.107 0.268528    
c(Industry)Residential Construction                  3.003e-01  6.538e-02   4.593 4.41e-06 ***
c(Industry)Resorts & Casinos                         2.058e-02  6.621e-02   0.311 0.755964    
c(Industry)Restaurants                              -2.281e-02  5.549e-02  -0.411 0.680993    
c(Industry)Scientific & Technical Instruments        9.432e-02  5.969e-02   1.580 0.114114    
c(Industry)Security & Protection Services            7.285e-02  7.288e-02   1.000 0.317540    
c(Industry)Semiconductor Equipment & Materials      -6.227e-02  6.042e-02  -1.031 0.302777    
c(Industry)Semiconductors                            1.734e-02  5.599e-02   0.310 0.756798    
c(Industry)Software - Application                   -7.072e-02  4.977e-02  -1.421 0.155348    
c(Industry)Software - Infrastructure                -9.274e-02  5.169e-02  -1.794 0.072800 .  
c(Industry)Solar                                     7.462e-03  9.482e-02   0.079 0.937277    
c(Industry)Specialty Business Services               4.255e-02  6.086e-02   0.699 0.484435    
c(Industry)Specialty Chemicals                       1.070e-01  5.432e-02   1.970 0.048902 *  
c(Industry)Specialty Industrial Machinery            1.056e-01  5.260e-02   2.009 0.044604 *  
c(Industry)Specialty Retail                          5.586e-02  5.674e-02   0.985 0.324864    
c(Industry)Staffing & Employment Services            1.725e-01  6.557e-02   2.630 0.008542 ** 
c(Industry)Steel                                     4.853e-02  7.984e-02   0.608 0.543274    
c(Industry)Telecom Services                         -5.665e-03  6.281e-02  -0.090 0.928136    
c(Industry)Textile Manufacturing                     1.402e-01  9.625e-02   1.457 0.145239    
c(Industry)Thermal Coal                              2.221e-01  8.586e-02   2.587 0.009690 ** 
c(Industry)Tobacco                                   2.073e-01  7.983e-02   2.597 0.009426 ** 
c(Industry)Tools & Accessories                       6.514e-02  7.249e-02   0.899 0.368818    
c(Industry)Travel Services                          -1.260e-01  7.287e-02  -1.729 0.083906 .  
c(Industry)Trucking                                 -2.596e-02  8.500e-02  -0.305 0.760095    
c(Industry)Uranium                                   2.531e-01  1.662e-01   1.523 0.127745    
c(Industry)Utilities - Diversified                   2.425e-01  8.885e-02   2.729 0.006360 ** 
c(Industry)Utilities - Independent Power Producers   1.340e-01  1.563e-01   0.857 0.391389    
c(Industry)Utilities - Regulated Electric           -2.339e-02  5.710e-02  -0.410 0.682088    
c(Industry)Utilities - Regulated Gas                -1.105e-01  7.457e-02  -1.482 0.138389    
c(Industry)Utilities - Regulated Water               8.156e-02  9.099e-02   0.896 0.370078    
c(Industry)Utilities - Renewable                     5.050e-01  1.482e-01   3.409 0.000654 ***
c(Industry)Waste Management                         -5.390e-02  7.593e-02  -0.710 0.477838    
Day_of_EarningsCall                                 -8.673e-05  1.462e-05  -5.931 3.09e-09 ***
Covid_Exposure                                       3.566e-01  3.472e-03 102.698  < 2e-16 ***
PRiskT_health                                        6.205e-07  2.669e-07   2.324 0.020123 *  
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.4224 on 13004 degrees of freedom
  (3290 observations deleted due to missingness)
Multiple R-squared:  0.5201,    Adjusted R-squared:  0.5148 
F-statistic:  97.2 on 145 and 13004 DF,  p-value: < 2.2e-16

Examines Negative COVID Sentiment across industries over time:


lm(Covid_Neg_Sentiment ~ c(Industry) + Day_of_EarningsCall + Covid_Exposure + PRiskT_health, data=Closing_Share_Price_Across_Time) |> 
  summary()

Call:
lm(formula = Covid_Neg_Sentiment ~ c(Industry) + Day_of_EarningsCall + 
    Covid_Exposure + PRiskT_health, data = Closing_Share_Price_Across_Time)

Residuals:
    Min      1Q  Median      3Q     Max 
-2.4738 -0.2176 -0.0387  0.1713  5.1861 

Coefficients:
                                                      Estimate Std. Error t value Pr(>|t|)    
(Intercept)                                          1.676e+00  2.780e-01   6.027 1.71e-09 ***
c(Industry)Aerospace & Defense                       6.841e-02  5.607e-02   1.220 0.222421    
c(Industry)Agricultural Inputs                       5.721e-03  8.260e-02   0.069 0.944779    
c(Industry)Airlines                                 -1.314e-02  6.950e-02  -0.189 0.850080    
c(Industry)Airports & Air Services                   1.911e-03  2.482e-01   0.008 0.993857    
c(Industry)Aluminum                                  3.150e-01  1.219e-01   2.584 0.009791 ** 
c(Industry)Apparel Manufacturing                     6.190e-02  6.171e-02   1.003 0.315895    
c(Industry)Apparel Retail                            6.605e-02  5.807e-02   1.137 0.255403    
c(Industry)Asset Management                          7.501e-02  5.157e-02   1.455 0.145768    
c(Industry)Auto & Truck Dealerships                  3.269e-02  6.426e-02   0.509 0.610993    
c(Industry)Auto Manufacturers                        7.705e-02  9.348e-02   0.824 0.409799    
c(Industry)Auto Parts                                2.359e-01  5.704e-02   4.136 3.56e-05 ***
c(Industry)Banks - Diversified                      -4.399e-02  9.221e-02  -0.477 0.633317    
c(Industry)Banks - Regional                          3.635e-02  4.935e-02   0.736 0.461464    
c(Industry)Beverages - Brewers                       4.497e-02  1.073e-01   0.419 0.675157    
c(Industry)Beverages - Non-Alcoholic                 1.192e-01  7.644e-02   1.560 0.118848    
c(Industry)Beverages - Wineries & Distilleries       5.583e-02  1.354e-01   0.412 0.680224    
c(Industry)Biotechnology                            -5.908e-02  4.864e-02  -1.215 0.224488    
c(Industry)Broadcasting                              4.561e-02  6.863e-02   0.665 0.506332    
c(Industry)Building Materials                        5.174e-02  9.099e-02   0.569 0.569627    
c(Industry)Building Products & Equipment             5.318e-02  5.871e-02   0.906 0.365085    
c(Industry)Business Equipment & Supplies             5.324e-02  1.306e-01   0.408 0.683438    
c(Industry)Capital Markets                           6.435e-02  7.145e-02   0.901 0.367769    
c(Industry)Chemicals                                 2.576e-01  8.116e-02   3.175 0.001504 ** 
c(Industry)Coking Coal                               8.783e-02  9.345e-02   0.940 0.347310    
c(Industry)Communication Equipment                   5.142e-02  5.544e-02   0.928 0.353652    
c(Industry)Computer Hardware                         3.250e-02  6.311e-02   0.515 0.606545    
c(Industry)Confectioners                             1.328e-02  1.184e-01   0.112 0.910719    
c(Industry)Conglomerates                             2.050e-02  6.642e-02   0.309 0.757552    
c(Industry)Consulting Services                      -6.984e-03  7.141e-02  -0.098 0.922085    
c(Industry)Consumer Electronics                      7.225e-02  8.335e-02   0.867 0.386010    
c(Industry)Copper                                   -1.640e-02  1.123e-01  -0.146 0.883925    
c(Industry)Credit Services                           6.258e-02  6.031e-02   1.038 0.299406    
c(Industry)Department Stores                        -1.529e-01  1.097e-01  -1.393 0.163568    
c(Industry)Diagnostics & Research                   -3.804e-01  5.362e-02  -7.095 1.36e-12 ***
c(Industry)Discount Stores                          -9.151e-02  7.369e-02  -1.242 0.214295    
c(Industry)Drug Manufacturers - General             -1.988e-01  7.058e-02  -2.816 0.004870 ** 
c(Industry)Drug Manufacturers - Specialty & Generic -6.273e-02  5.428e-02  -1.156 0.247872    
c(Industry)Education & Training Services            -2.988e-02  6.836e-02  -0.437 0.662003    
c(Industry)Electrical Equipment & Parts              1.200e-01  6.312e-02   1.902 0.057227 .  
c(Industry)Electronic Components                     2.063e-01  5.613e-02   3.675 0.000238 ***
c(Industry)Electronic Gaming & Multimedia           -1.262e-01  1.413e-01  -0.893 0.371837    
c(Industry)Electronics & Computer Distribution       5.834e-02  8.678e-02   0.672 0.501424    
c(Industry)Engineering & Construction                8.248e-02  5.673e-02   1.454 0.146033    
c(Industry)Entertainment                             1.579e-01  6.052e-02   2.608 0.009105 ** 
c(Industry)Farm & Heavy Construction Machinery       1.556e-01  6.121e-02   2.542 0.011027 *  
c(Industry)Farm Products                            -1.148e-02  7.694e-02  -0.149 0.881414    
c(Industry)Financial Conglomerates                   8.773e-02  1.219e-01   0.720 0.471836    
c(Industry)Financial Data & Stock Exchanges         -1.814e-02  7.597e-02  -0.239 0.811325    
c(Industry)Food Distribution                        -5.915e-02  7.453e-02  -0.794 0.427428    
c(Industry)Footwear & Accessories                    6.602e-02  6.642e-02   0.994 0.320265    
c(Industry)Furnishings, Fixtures & Appliances        1.978e-01  6.009e-02   3.292 0.000997 ***
c(Industry)Gambling                                 -6.433e-02  8.115e-02  -0.793 0.427933    
c(Industry)Gold                                     -1.003e-01  8.984e-02  -1.117 0.264123    
c(Industry)Grocery Stores                           -2.184e-01  8.587e-02  -2.544 0.010975 *  
c(Industry)Health Information Services              -1.300e-01  5.833e-02  -2.228 0.025911 *  
c(Industry)Healthcare Plans                         -4.482e-01  7.373e-02  -6.079 1.24e-09 ***
c(Industry)Home Improvement Retail                   1.676e-01  8.877e-02   1.888 0.059059 .  
c(Industry)Household & Personal Products             1.026e-01  6.158e-02   1.666 0.095805 .  
c(Industry)Industrial Distribution                   5.505e-02  6.391e-02   0.861 0.389089    
c(Industry)Information Technology Services          -5.359e-02  5.673e-02  -0.945 0.344918    
c(Industry)Infrastructure Operations                 1.238e-01  1.945e-01   0.637 0.524211    
c(Industry)Insurance - Diversified                   1.832e-01  1.051e-01   1.744 0.081265 .  
c(Industry)Insurance - Life                          4.146e-01  6.820e-02   6.079 1.25e-09 ***
c(Industry)Insurance - Property & Casualty           4.603e-01  5.663e-02   8.128 4.77e-16 ***
c(Industry)Insurance - Reinsurance                   7.452e-01  1.575e-01   4.732 2.25e-06 ***
c(Industry)Insurance - Specialty                     3.791e-01  7.074e-02   5.359 8.52e-08 ***
c(Industry)Insurance Brokers                         1.764e-01  8.052e-02   2.190 0.028521 *  
c(Industry)Integrated Freight & Logistics           -2.131e-02  7.010e-02  -0.304 0.761159    
c(Industry)Internet Content & Information           -8.723e-02  6.311e-02  -1.382 0.166928    
c(Industry)Internet Retail                           1.605e-02  7.454e-02   0.215 0.829481    
c(Industry)Leisure                                   3.043e-02  6.557e-02   0.464 0.642638    
c(Industry)Lodging                                  -6.653e-03  8.048e-02  -0.083 0.934115    
c(Industry)Lumber & Wood Production                  5.976e-02  1.097e-01   0.545 0.585946    
c(Industry)Luxury Goods                             -1.290e-01  1.051e-01  -1.228 0.219638    
c(Industry)Marine Shipping                           1.971e-01  9.624e-02   2.048 0.040585 *  
c(Industry)Medical Care Facilities                  -9.980e-02  5.629e-02  -1.773 0.076289 .  
c(Industry)Medical Devices                          -1.057e-01  4.981e-02  -2.121 0.033901 *  
c(Industry)Medical Distribution                     -2.675e-01  7.600e-02  -3.520 0.000433 ***
c(Industry)Medical Instruments & Supplies           -2.374e-01  5.411e-02  -4.387 1.16e-05 ***
c(Industry)Metal Fabrication                         2.472e-01  6.836e-02   3.616 0.000300 ***
c(Industry)Mortgage Finance                          1.988e-01  8.415e-02   2.362 0.018179 *  
c(Industry)Oil & Gas Drilling                        3.796e-01  1.304e-01   2.912 0.003593 ** 
c(Industry)Oil & Gas E&P                             8.586e-02  6.080e-02   1.412 0.157939    
c(Industry)Oil & Gas Equipment & Services            2.648e-01  5.669e-02   4.671 3.02e-06 ***
c(Industry)Oil & Gas Integrated                      2.340e-02  1.184e-01   0.198 0.843349    
c(Industry)Oil & Gas Midstream                       4.161e-02  6.579e-02   0.632 0.527155    
c(Industry)Oil & Gas Refining & Marketing            1.160e-01  7.009e-02   1.654 0.098058 .  
c(Industry)Other Industrial Metals & Mining          1.422e-01  1.304e-01   1.091 0.275329    
c(Industry)Other Precious Metals & Mining            5.371e-02  1.482e-01   0.362 0.716989    
c(Industry)Packaged Foods                           -2.848e-02  5.477e-02  -0.520 0.603010    
c(Industry)Packaging & Containers                   -2.823e-02  6.312e-02  -0.447 0.654660    
c(Industry)Paper & Paper Products                    1.137e-01  1.785e-01   0.637 0.524106    
c(Industry)Personal Services                         5.035e-02  7.546e-02   0.667 0.504608    
c(Industry)Pharmaceutical Retailers                 -1.121e-03  1.304e-01  -0.009 0.993141    
c(Industry)Pollution & Treatment Controls            7.877e-02  9.480e-02   0.831 0.406035    
c(Industry)Publishing                                3.671e-01  9.098e-02   4.035 5.49e-05 ***
c(Industry)Railroads                                 1.136e-01  7.369e-02   1.542 0.123208    
c(Industry)Real Estate - Development                 1.511e-01  1.413e-01   1.069 0.285123    
c(Industry)Real Estate - Diversified                -1.192e-01  1.785e-01  -0.668 0.504303    
c(Industry)Real Estate Services                      2.131e-02  6.980e-02   0.305 0.760164    
c(Industry)Recreational Vehicles                     9.400e-02  7.804e-02   1.204 0.228429    
c(Industry)REIT - Diversified                       -1.490e-02  7.455e-02  -0.200 0.841544    
c(Industry)REIT - Healthcare Facilities             -1.340e-01  6.673e-02  -2.008 0.044685 *  
c(Industry)REIT - Hotel & Motel                      1.415e-02  6.361e-02   0.222 0.823982    
c(Industry)REIT - Industrial                        -3.520e-02  7.456e-02  -0.472 0.636899    
c(Industry)REIT - Mortgage                           1.117e-01  5.620e-02   1.988 0.046888 *  
c(Industry)REIT - Office                            -1.881e-02  6.499e-02  -0.289 0.772241    
c(Industry)REIT - Residential                       -3.839e-02  6.392e-02  -0.601 0.548152    
c(Industry)REIT - Retail                            -1.327e-02  6.210e-02  -0.214 0.830783    
c(Industry)REIT - Specialty                         -2.085e-03  6.359e-02  -0.033 0.973840    
c(Industry)Rental & Leasing Services                 7.535e-02  6.810e-02   1.107 0.268528    
c(Industry)Residential Construction                  3.003e-01  6.538e-02   4.593 4.41e-06 ***
c(Industry)Resorts & Casinos                         2.058e-02  6.621e-02   0.311 0.755964    
c(Industry)Restaurants                              -2.281e-02  5.549e-02  -0.411 0.680993    
c(Industry)Scientific & Technical Instruments        9.432e-02  5.969e-02   1.580 0.114114    
c(Industry)Security & Protection Services            7.285e-02  7.288e-02   1.000 0.317540    
c(Industry)Semiconductor Equipment & Materials      -6.227e-02  6.042e-02  -1.031 0.302777    
c(Industry)Semiconductors                            1.734e-02  5.599e-02   0.310 0.756798    
c(Industry)Software - Application                   -7.072e-02  4.977e-02  -1.421 0.155348    
c(Industry)Software - Infrastructure                -9.274e-02  5.169e-02  -1.794 0.072800 .  
c(Industry)Solar                                     7.462e-03  9.482e-02   0.079 0.937277    
c(Industry)Specialty Business Services               4.255e-02  6.086e-02   0.699 0.484435    
c(Industry)Specialty Chemicals                       1.070e-01  5.432e-02   1.970 0.048902 *  
c(Industry)Specialty Industrial Machinery            1.056e-01  5.260e-02   2.009 0.044604 *  
c(Industry)Specialty Retail                          5.586e-02  5.674e-02   0.985 0.324864    
c(Industry)Staffing & Employment Services            1.725e-01  6.557e-02   2.630 0.008542 ** 
c(Industry)Steel                                     4.853e-02  7.984e-02   0.608 0.543274    
c(Industry)Telecom Services                         -5.665e-03  6.281e-02  -0.090 0.928136    
c(Industry)Textile Manufacturing                     1.402e-01  9.625e-02   1.457 0.145239    
c(Industry)Thermal Coal                              2.221e-01  8.586e-02   2.587 0.009690 ** 
c(Industry)Tobacco                                   2.073e-01  7.983e-02   2.597 0.009426 ** 
c(Industry)Tools & Accessories                       6.514e-02  7.249e-02   0.899 0.368818    
c(Industry)Travel Services                          -1.260e-01  7.287e-02  -1.729 0.083906 .  
c(Industry)Trucking                                 -2.596e-02  8.500e-02  -0.305 0.760095    
c(Industry)Uranium                                   2.531e-01  1.662e-01   1.523 0.127745    
c(Industry)Utilities - Diversified                   2.425e-01  8.885e-02   2.729 0.006360 ** 
c(Industry)Utilities - Independent Power Producers   1.340e-01  1.563e-01   0.857 0.391389    
c(Industry)Utilities - Regulated Electric           -2.339e-02  5.710e-02  -0.410 0.682088    
c(Industry)Utilities - Regulated Gas                -1.105e-01  7.457e-02  -1.482 0.138389    
c(Industry)Utilities - Regulated Water               8.156e-02  9.099e-02   0.896 0.370078    
c(Industry)Utilities - Renewable                     5.050e-01  1.482e-01   3.409 0.000654 ***
c(Industry)Waste Management                         -5.390e-02  7.593e-02  -0.710 0.477838    
Day_of_EarningsCall                                 -8.673e-05  1.462e-05  -5.931 3.09e-09 ***
Covid_Exposure                                       3.566e-01  3.472e-03 102.698  < 2e-16 ***
PRiskT_health                                        6.205e-07  2.669e-07   2.324 0.020123 *  
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 0.4224 on 13004 degrees of freedom
  (3290 observations deleted due to missingness)
Multiple R-squared:  0.5201,    Adjusted R-squared:  0.5148 
F-statistic:  97.2 on 145 and 13004 DF,  p-value: < 2.2e-16

lm(Percent_Change_bt_DayBefore_y_DayAfter ~ c(Industry) + Day_of_EarningsCall + Covid_Net_Sentiment + Covid_Net_Sentiment:c(Industry), data=Closing_Share_Price_Across_Time) |> 
  summary()

Call:
lm(formula = Percent_Change_bt_DayBefore_y_DayAfter ~ c(Industry) + 
    Day_of_EarningsCall + Covid_Net_Sentiment + Covid_Net_Sentiment:c(Industry), 
    data = Closing_Share_Price_Across_Time)

Residuals:
     Min       1Q   Median       3Q      Max 
-101.070   -4.740   -0.264    4.372  252.209 

Coefficients:
                                                                          Estimate Std. Error t value Pr(>|t|)    
(Intercept)                                                              1.743e+01  6.596e+00   2.642  0.00825 ** 
c(Industry)Aerospace & Defense                                           3.758e-01  1.434e+00   0.262  0.79322    
c(Industry)Agricultural Inputs                                           1.865e+00  2.147e+00   0.869  0.38504    
c(Industry)Airlines                                                      7.405e-01  1.791e+00   0.413  0.67936    
c(Industry)Airports & Air Services                                      -2.520e+00  6.174e+00  -0.408  0.68318    
c(Industry)Aluminum                                                     -1.372e+00  3.558e+00  -0.386  0.69987    
c(Industry)Apparel Manufacturing                                         8.475e-01  1.546e+00   0.548  0.58354    
c(Industry)Apparel Retail                                                2.441e+00  1.487e+00   1.642  0.10061    
c(Industry)Asset Management                                              2.544e+00  1.306e+00   1.948  0.05147 .  
c(Industry)Auto & Truck Dealerships                                      1.835e+00  1.672e+00   1.097  0.27249    
c(Industry)Auto Manufacturers                                           -8.148e-01  2.415e+00  -0.337  0.73585    
c(Industry)Auto Parts                                                    2.610e+00  1.479e+00   1.765  0.07760 .  
c(Industry)Banks - Diversified                                          -1.430e+00  2.759e+00  -0.518  0.60429    
c(Industry)Banks - Regional                                              1.970e+00  1.256e+00   1.568  0.11679    
c(Industry)Beverages - Brewers                                           3.299e+00  3.077e+00   1.072  0.28374    
c(Industry)Beverages - Non-Alcoholic                                    -1.564e+00  1.917e+00  -0.816  0.41466    
c(Industry)Beverages - Wineries & Distilleries                          -2.491e+00  4.391e+00  -0.567  0.57051    
c(Industry)Biotechnology                                                 1.144e-01  1.221e+00   0.094  0.92532    
c(Industry)Broadcasting                                                  3.987e+00  1.742e+00   2.289  0.02208 *  
c(Industry)Building Materials                                            1.075e+00  2.899e+00   0.371  0.71075    
c(Industry)Building Products & Equipment                                 1.601e+00  1.497e+00   1.069  0.28495    
c(Industry)Business Equipment & Supplies                                -2.207e+00  3.643e+00  -0.606  0.54469    
c(Industry)Capital Markets                                               1.053e+00  1.864e+00   0.565  0.57219    
c(Industry)Chemicals                                                     2.992e+00  2.075e+00   1.442  0.14919    
c(Industry)Coking Coal                                                   2.466e+00  2.587e+00   0.953  0.34048    
c(Industry)Communication Equipment                                       4.321e-01  1.427e+00   0.303  0.76204    
c(Industry)Computer Hardware                                             1.935e+00  1.573e+00   1.230  0.21877    
c(Industry)Confectioners                                                 9.747e-01  3.109e+00   0.314  0.75390    
c(Industry)Conglomerates                                                 8.017e-01  1.695e+00   0.473  0.63626    
c(Industry)Consulting Services                                           2.050e+00  1.798e+00   1.140  0.25419    
c(Industry)Consumer Electronics                                          1.340e+00  2.279e+00   0.588  0.55677    
c(Industry)Copper                                                       -1.382e-01  3.136e+00  -0.044  0.96487    
c(Industry)Credit Services                                               4.875e+00  1.576e+00   3.093  0.00199 ** 
c(Industry)Department Stores                                            -8.050e-01  2.671e+00  -0.301  0.76311    
c(Industry)Diagnostics & Research                                        6.397e-01  1.329e+00   0.481  0.63026    
c(Industry)Discount Stores                                              -7.672e-01  1.809e+00  -0.424  0.67158    
c(Industry)Drug Manufacturers - General                                  4.484e-01  1.737e+00   0.258  0.79627    
c(Industry)Drug Manufacturers - Specialty & Generic                     -3.131e-01  1.351e+00  -0.232  0.81668    
c(Industry)Education & Training Services                                 2.294e+00  1.736e+00   1.322  0.18636    
c(Industry)Electrical Equipment & Parts                                 -1.279e+00  1.657e+00  -0.772  0.44021    
c(Industry)Electronic Components                                         1.731e+00  1.490e+00   1.162  0.24525    
c(Industry)Electronic Gaming & Multimedia                                5.880e+00  3.463e+00   1.698  0.08959 .  
c(Industry)Electronics & Computer Distribution                           3.573e+00  2.247e+00   1.590  0.11180    
c(Industry)Engineering & Construction                                    9.739e-01  1.452e+00   0.671  0.50228    
c(Industry)Entertainment                                                 1.290e+00  1.563e+00   0.825  0.40919    
c(Industry)Farm & Heavy Construction Machinery                           8.897e-01  1.635e+00   0.544  0.58628    
c(Industry)Farm Products                                                -1.957e+00  1.937e+00  -1.010  0.31238    
c(Industry)Financial Conglomerates                                       4.288e+00  3.298e+00   1.300  0.19358    
c(Industry)Financial Data & Stock Exchanges                             -2.751e-02  1.967e+00  -0.014  0.98884    
c(Industry)Food Distribution                                             2.158e-01  1.845e+00   0.117  0.90688    
c(Industry)Footwear & Accessories                                        8.141e-01  1.753e+00   0.464  0.64241    
c(Industry)Furnishings, Fixtures & Appliances                            2.902e-01  1.580e+00   0.184  0.85425    
c(Industry)Gambling                                                      4.165e+00  2.003e+00   2.079  0.03764 *  
c(Industry)Gold                                                          1.352e+00  2.210e+00   0.612  0.54055    
c(Industry)Grocery Stores                                                2.341e+00  2.097e+00   1.117  0.26421    
c(Industry)Health Information Services                                  -1.033e+00  1.475e+00  -0.700  0.48373    
c(Industry)Healthcare Plans                                              8.313e-01  1.837e+00   0.453  0.65085    
c(Industry)Home Improvement Retail                                       1.159e+00  2.292e+00   0.506  0.61320    
c(Industry)Household & Personal Products                                 2.214e+00  1.551e+00   1.428  0.15344    
c(Industry)Industrial Distribution                                       1.558e+00  1.640e+00   0.950  0.34211    
c(Industry)Information Technology Services                               2.762e+00  1.425e+00   1.939  0.05256 .  
c(Industry)Infrastructure Operations                                     1.781e+00  5.626e+00   0.316  0.75165    
c(Industry)Insurance - Diversified                                       4.120e+00  2.898e+00   1.422  0.15512    
c(Industry)Insurance - Life                                              8.962e-02  1.867e+00   0.048  0.96171    
c(Industry)Insurance - Property & Casualty                               1.761e+00  1.546e+00   1.139  0.25458    
c(Industry)Insurance - Reinsurance                                      -4.851e+00  9.098e+00  -0.533  0.59389    
c(Industry)Insurance - Specialty                                        -1.741e-01  1.937e+00  -0.090  0.92840    
c(Industry)Insurance Brokers                                            -3.502e+00  2.190e+00  -1.599  0.10985    
c(Industry)Integrated Freight & Logistics                                2.193e+00  1.786e+00   1.228  0.21950    
c(Industry)Internet Content & Information                                3.898e+00  1.571e+00   2.481  0.01311 *  
c(Industry)Internet Retail                                               1.645e+00  1.912e+00   0.860  0.38962    
c(Industry)Leisure                                                       2.286e+00  1.695e+00   1.349  0.17739    
c(Industry)Lodging                                                       1.413e+00  2.110e+00   0.670  0.50306    
c(Industry)Lumber & Wood Production                                      2.147e+00  2.782e+00   0.772  0.44037    
c(Industry)Luxury Goods                                                 -1.416e+00  2.626e+00  -0.539  0.58964    
c(Industry)Marine Shipping                                               6.561e-01  2.905e+00   0.226  0.82135    
c(Industry)Medical Care Facilities                                       1.882e+00  1.409e+00   1.336  0.18144    
c(Industry)Medical Devices                                               1.635e-01  1.247e+00   0.131  0.89565    
c(Industry)Medical Distribution                                          5.493e-03  1.863e+00   0.003  0.99765    
c(Industry)Medical Instruments & Supplies                                7.368e-01  1.346e+00   0.548  0.58399    
c(Industry)Metal Fabrication                                            -8.233e-03  1.874e+00  -0.004  0.99649    
c(Industry)Mortgage Finance                                              1.964e+00  2.452e+00   0.801  0.42304    
c(Industry)Oil & Gas Drilling                                            1.092e+00  4.231e+00   0.258  0.79641    
c(Industry)Oil & Gas E&P                                                 1.479e+00  1.622e+00   0.912  0.36199    
c(Industry)Oil & Gas Equipment & Services                                7.469e-02  1.492e+00   0.050  0.96008    
c(Industry)Oil & Gas Integrated                                          1.030e+00  3.055e+00   0.337  0.73611    
c(Industry)Oil & Gas Midstream                                           9.316e-01  1.732e+00   0.538  0.59063    
c(Industry)Oil & Gas Refining & Marketing                                2.432e+00  1.853e+00   1.312  0.18947    
c(Industry)Other Industrial Metals & Mining                             -1.201e+00  4.173e+00  -0.288  0.77357    
c(Industry)Other Precious Metals & Mining                                4.104e+00  4.112e+00   0.998  0.31836    
c(Industry)Packaged Foods                                                5.365e-01  1.369e+00   0.392  0.69525    
c(Industry)Packaging & Containers                                        1.329e+00  1.590e+00   0.836  0.40319    
c(Industry)Paper & Paper Products                                       -1.319e+01  9.298e+00  -1.418  0.15609    
c(Industry)Personal Services                                             1.619e+00  1.990e+00   0.813  0.41599    
c(Industry)Pharmaceutical Retailers                                     -1.539e+00  3.531e+00  -0.436  0.66302    
c(Industry)Pollution & Treatment Controls                                1.310e+00  2.511e+00   0.522  0.60189    
c(Industry)Publishing                                                    1.607e+00  2.516e+00   0.639  0.52289    
c(Industry)Railroads                                                     1.642e+00  2.079e+00   0.790  0.42963    
c(Industry)Real Estate - Development                                     4.436e+00  4.353e+00   1.019  0.30819    
c(Industry)Real Estate - Diversified                                     1.519e+00  4.388e+00   0.346  0.72914    
c(Industry)Real Estate Services                                          2.888e+00  1.782e+00   1.621  0.10511    
c(Industry)Recreational Vehicles                                         5.774e-01  2.084e+00   0.277  0.78176    
c(Industry)REIT - Diversified                                            1.531e-02  1.853e+00   0.008  0.99341    
c(Industry)REIT - Healthcare Facilities                                  1.578e+00  1.652e+00   0.955  0.33956    
c(Industry)REIT - Hotel & Motel                                          9.974e-01  1.594e+00   0.626  0.53146    
c(Industry)REIT - Industrial                                             6.296e-01  1.869e+00   0.337  0.73627    
c(Industry)REIT - Mortgage                                               8.144e-01  1.437e+00   0.567  0.57081    
c(Industry)REIT - Office                                                 8.773e-01  1.650e+00   0.532  0.59495    
c(Industry)REIT - Residential                                            1.799e+00  1.620e+00   1.110  0.26704    
c(Industry)REIT - Retail                                                 1.793e+00  1.567e+00   1.144  0.25276    
c(Industry)REIT - Specialty                                              1.069e+00  1.596e+00   0.670  0.50275    
c(Industry)Rental & Leasing Services                                     5.975e-01  1.773e+00   0.337  0.73617    
c(Industry)Residential Construction                                      2.891e+00  1.792e+00   1.613  0.10667    
c(Industry)Resorts & Casinos                                             1.988e+00  1.674e+00   1.188  0.23491    
c(Industry)Restaurants                                                   2.911e+00  1.391e+00   2.093  0.03640 *  
c(Industry)Scientific & Technical Instruments                            2.572e-01  1.561e+00   0.165  0.86915    
c(Industry)Security & Protection Services                               -1.863e+00  1.933e+00  -0.964  0.33527    
c(Industry)Semiconductor Equipment & Materials                           1.326e+00  1.509e+00   0.879  0.37967    
c(Industry)Semiconductors                                                3.560e+00  1.407e+00   2.530  0.01141 *  
c(Industry)Software - Application                                        1.404e-01  1.248e+00   0.112  0.91044    
c(Industry)Software - Infrastructure                                     8.872e-01  1.293e+00   0.686  0.49265    
c(Industry)Solar                                                         4.095e+00  2.392e+00   1.712  0.08693 .  
c(Industry)Specialty Business Services                                  -1.176e-01  1.599e+00  -0.074  0.94134    
c(Industry)Specialty Chemicals                                           2.209e-01  1.385e+00   0.160  0.87321    
c(Industry)Specialty Industrial Machinery                                1.482e+00  1.347e+00   1.100  0.27148    
c(Industry)Specialty Retail                                              2.839e+00  1.482e+00   1.915  0.05551 .  
c(Industry)Staffing & Employment Services                                3.114e+00  1.724e+00   1.807  0.07082 .  
c(Industry)Steel                                                         2.492e+00  2.047e+00   1.217  0.22363    
c(Industry)Telecom Services                                              1.059e+00  1.609e+00   0.658  0.51029    
c(Industry)Textile Manufacturing                                        -3.035e+00  2.425e+00  -1.252  0.21075    
c(Industry)Thermal Coal                                                  9.257e-01  2.363e+00   0.392  0.69523    
c(Industry)Tobacco                                                       1.940e+00  2.227e+00   0.871  0.38353    
c(Industry)Tools & Accessories                                           7.563e-02  1.877e+00   0.040  0.96787    
c(Industry)Travel Services                                               1.106e+00  1.789e+00   0.618  0.53656    
c(Industry)Trucking                                                      2.388e+00  2.379e+00   1.004  0.31548    
c(Industry)Uranium                                                      -6.731e+00  4.158e+00  -1.619  0.10548    
c(Industry)Utilities - Diversified                                       1.090e+00  2.571e+00   0.424  0.67144    
c(Industry)Utilities - Independent Power Producers                       2.698e+00  4.727e+00   0.571  0.56823    
c(Industry)Utilities - Regulated Electric                                1.100e+00  1.459e+00   0.754  0.45069    
c(Industry)Utilities - Regulated Gas                                     2.054e+00  1.931e+00   1.064  0.28741    
c(Industry)Utilities - Regulated Water                                   2.236e+00  2.599e+00   0.861  0.38953    
c(Industry)Utilities - Renewable                                         1.766e+00  4.688e+00   0.377  0.70636    
c(Industry)Waste Management                                              7.522e-01  1.861e+00   0.404  0.68615    
Day_of_EarningsCall                                                     -9.712e-04  3.475e-04  -2.795  0.00520 ** 
Covid_Net_Sentiment                                                      6.724e-01  1.815e+00   0.370  0.71108    
c(Industry)Aerospace & Defense:Covid_Net_Sentiment                       1.986e-01  2.233e+00   0.089  0.92912    
c(Industry)Agricultural Inputs:Covid_Net_Sentiment                       1.646e+00  4.551e+00   0.362  0.71767    
c(Industry)Airlines:Covid_Net_Sentiment                                  3.316e+00  4.178e+00   0.794  0.42734    
c(Industry)Airports & Air Services:Covid_Net_Sentiment                   2.314e+01  2.017e+01   1.147  0.25132    
c(Industry)Aluminum:Covid_Net_Sentiment                                  2.642e-01  4.306e+00   0.061  0.95107    
c(Industry)Apparel Manufacturing:Covid_Net_Sentiment                    -1.495e+00  2.480e+00  -0.603  0.54657    
c(Industry)Apparel Retail:Covid_Net_Sentiment                           -3.237e+00  2.676e+00  -1.210  0.22648    
c(Industry)Asset Management:Covid_Net_Sentiment                          1.387e+00  2.082e+00   0.666  0.50530    
c(Industry)Auto & Truck Dealerships:Covid_Net_Sentiment                 -6.247e+00  3.220e+00  -1.940  0.05240 .  
c(Industry)Auto Manufacturers:Covid_Net_Sentiment                       -1.169e+00  6.440e+00  -0.182  0.85597    
c(Industry)Auto Parts:Covid_Net_Sentiment                                1.859e-01  2.096e+00   0.089  0.92931    
c(Industry)Banks - Diversified:Covid_Net_Sentiment                       6.888e-01  1.083e+01   0.064  0.94928    
c(Industry)Banks - Regional:Covid_Net_Sentiment                         -3.184e-01  2.060e+00  -0.155  0.87720    
c(Industry)Beverages - Brewers:Covid_Net_Sentiment                       8.117e+00  6.495e+00   1.250  0.21145    
c(Industry)Beverages - Non-Alcoholic:Covid_Net_Sentiment                -8.903e-01  2.832e+00  -0.314  0.75328    
c(Industry)Beverages - Wineries & Distilleries:Covid_Net_Sentiment       1.494e+00  9.720e+00   0.154  0.87788    
c(Industry)Biotechnology:Covid_Net_Sentiment                            -3.761e-01  1.909e+00  -0.197  0.84383    
c(Industry)Broadcasting:Covid_Net_Sentiment                              4.166e+00  2.837e+00   1.468  0.14207    
c(Industry)Building Materials:Covid_Net_Sentiment                       -1.810e+00  8.395e+00  -0.216  0.82935    
c(Industry)Building Products & Equipment:Covid_Net_Sentiment            -3.729e-01  2.731e+00  -0.137  0.89139    
c(Industry)Business Equipment & Supplies:Covid_Net_Sentiment             1.659e+00  7.172e+00   0.231  0.81711    
c(Industry)Capital Markets:Covid_Net_Sentiment                           2.078e+00  4.193e+00   0.496  0.62022    
c(Industry)Chemicals:Covid_Net_Sentiment                                 2.387e+00  2.535e+00   0.942  0.34643    
c(Industry)Coking Coal:Covid_Net_Sentiment                               3.572e+00  4.773e+00   0.748  0.45419    
c(Industry)Communication Equipment:Covid_Net_Sentiment                   5.077e-01  2.306e+00   0.220  0.82572    
c(Industry)Computer Hardware:Covid_Net_Sentiment                        -2.188e+00  2.353e+00  -0.930  0.35242    
c(Industry)Confectioners:Covid_Net_Sentiment                             2.229e+00  7.009e+00   0.318  0.75046    
c(Industry)Conglomerates:Covid_Net_Sentiment                            -1.015e+00  2.753e+00  -0.369  0.71234    
c(Industry)Consulting Services:Covid_Net_Sentiment                       6.793e-01  3.376e+00   0.201  0.84053    
c(Industry)Consumer Electronics:Covid_Net_Sentiment                      8.662e+00  3.961e+00   2.187  0.02879 *  
c(Industry)Copper:Covid_Net_Sentiment                                   -1.163e+00  7.483e+00  -0.155  0.87646    
c(Industry)Credit Services:Covid_Net_Sentiment                          -1.016e-02  2.782e+00  -0.004  0.99709    
c(Industry)Department Stores:Covid_Net_Sentiment                        -3.866e+00  6.253e+00  -0.618  0.53639    
c(Industry)Diagnostics & Research:Covid_Net_Sentiment                   -3.528e-01  2.070e+00  -0.170  0.86470    
c(Industry)Discount Stores:Covid_Net_Sentiment                           1.647e+01  4.257e+00   3.869  0.00011 ***
c(Industry)Drug Manufacturers - General:Covid_Net_Sentiment             -2.065e+00  3.007e+00  -0.687  0.49226    
c(Industry)Drug Manufacturers - Specialty & Generic:Covid_Net_Sentiment -1.330e+00  2.017e+00  -0.659  0.50964    
c(Industry)Education & Training Services:Covid_Net_Sentiment            -2.950e-01  3.108e+00  -0.095  0.92437    
c(Industry)Electrical Equipment & Parts:Covid_Net_Sentiment              1.531e+00  2.670e+00   0.573  0.56647    
c(Industry)Electronic Components:Covid_Net_Sentiment                    -2.787e-01  2.192e+00  -0.127  0.89883    
c(Industry)Electronic Gaming & Multimedia:Covid_Net_Sentiment            8.812e+00  2.039e+01   0.432  0.66557    
c(Industry)Electronics & Computer Distribution:Covid_Net_Sentiment       3.557e+00  3.545e+00   1.003  0.31577    
c(Industry)Engineering & Construction:Covid_Net_Sentiment               -2.220e+00  2.401e+00  -0.925  0.35518    
c(Industry)Entertainment:Covid_Net_Sentiment                            -7.746e-01  2.226e+00  -0.348  0.72790    
c(Industry)Farm & Heavy Construction Machinery:Covid_Net_Sentiment      -1.301e+00  2.610e+00  -0.499  0.61809    
c(Industry)Farm Products:Covid_Net_Sentiment                            -1.060e+00  3.573e+00  -0.297  0.76667    
c(Industry)Financial Conglomerates:Covid_Net_Sentiment                   9.373e+00  7.763e+00   1.207  0.22726    
c(Industry)Financial Data & Stock Exchanges:Covid_Net_Sentiment         -1.573e+00  5.623e+00  -0.280  0.77974    
c(Industry)Food Distribution:Covid_Net_Sentiment                        -8.323e-01  3.630e+00  -0.229  0.81865    
c(Industry)Footwear & Accessories:Covid_Net_Sentiment                   -1.018e+00  3.085e+00  -0.330  0.74127    
c(Industry)Furnishings, Fixtures & Appliances:Covid_Net_Sentiment       -1.655e+00  2.509e+00  -0.660  0.50950    
c(Industry)Gambling:Covid_Net_Sentiment                                  4.739e+00  4.133e+00   1.147  0.25152    
c(Industry)Gold:Covid_Net_Sentiment                                      3.397e+00  4.916e+00   0.691  0.48958    
c(Industry)Grocery Stores:Covid_Net_Sentiment                           -9.964e+00  4.357e+00  -2.287  0.02221 *  
c(Industry)Health Information Services:Covid_Net_Sentiment              -3.500e+00  2.535e+00  -1.381  0.16737    
 [ reached getOption("max.print") -- omitted 87 rows ]
---
Signif. codes:  0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1

Residual standard error: 10.18 on 12710 degrees of freedom
  (3443 observations deleted due to missingness)
Multiple R-squared:  0.02655,   Adjusted R-squared:  0.004647 
F-statistic: 1.212 on 286 and 12710 DF,  p-value: 0.008807

PercentChange_SharePrices_HierchicalIndustryCompany_RandomIndustryFirms <- glmer(
  "Percent_Change_bt_DayBefore_y_DayAfter ~ Day_of_EarningsCall + Covid_Net_Sentiment + (1 | Industry/company_name)", 
  data=Closing_Share_Price_Across_Time,
  family=gaussian) 
Warning: calling glmer() with family=gaussian (identity link) as a shortcut to lmer() is deprecated; please call lmer() directly
PercentChange_SharePrices_HierchicalIndustryCompany_RandomIndustryFirms 
Linear mixed model fit by REML ['lmerMod']
Formula: Percent_Change_bt_DayBefore_y_DayAfter ~ Day_of_EarningsCall +      Covid_Net_Sentiment + (1 | Industry/company_name)
   Data: Closing_Share_Price_Across_Time
REML criterion at convergence: 97238.78
Random effects:
 Groups                Name        Std.Dev.
 company_name:Industry (Intercept)  1.4651 
 Industry              (Intercept)  0.6788 
 Residual                          10.0722 
Number of obs: 12997, groups:  company_name:Industry, 2586; Industry, 143
Fixed Effects:
        (Intercept)  Day_of_EarningsCall  Covid_Net_Sentiment  
         18.6028533           -0.0009705            0.6382260  
summary(PercentChange_SharePrices_HierchicalIndustryCompany_RandomIndustryFirms)$coefficients  
                         Estimate   Std. Error   t value
(Intercept)         18.6028532790 6.3945309386  2.909182
Day_of_EarningsCall -0.0009704803 0.0003424276 -2.834118
Covid_Net_Sentiment  0.6382259795 0.1578113085  4.044235

p-value for Day_of_EarningsCall < 0.05 p-value for Covid_Net_Sentiment < 0.01

tidy(PercentChange_SharePrices_HierchicalIndustryCompany_RandomIndustryFirms)

PercentChange_SharePrices_HierchicalIndustryCompany <- glmer(
  "Percent_Change_bt_DayBefore_y_DayAfter ~ -1 + Day_of_EarningsCall + c(Industry) + Covid_Net_Sentiment:c(Industry) + (1 | company_name)", 
  data=Closing_Share_Price_Across_Time,
  family=gaussian) 
Warning: calling glmer() with family=gaussian (identity link) as a shortcut to lmer() is deprecated; please call lmer() directlyWarning: Some predictor variables are on very different scales: consider rescaling
summary(PercentChange_SharePrices_HierchicalIndustryCompany)$coefficients  
                                                                             Estimate   Std. Error      t value
Day_of_EarningsCall                                                     -9.769405e-04 3.471044e-04 -2.814543610
c(Industry)Advertising Agencies                                          1.752299e+01 6.600386e+00  2.654843495
c(Industry)Aerospace & Defense                                           1.792309e+01 6.543940e+00  2.738884005
c(Industry)Agricultural Inputs                                           1.932752e+01 6.732813e+00  2.870645058
c(Industry)Airlines                                                      1.825161e+01 6.647717e+00  2.745545148
c(Industry)Airports & Air Services                                       1.501707e+01 8.919247e+00  1.683670101
c(Industry)Aluminum                                                      1.619739e+01 7.347254e+00  2.204549684
c(Industry)Apparel Manufacturing                                         1.837053e+01 6.580083e+00  2.791838960
c(Industry)Apparel Retail                                                1.999504e+01 6.563559e+00  3.046371535
c(Industry)Asset Management                                              2.008727e+01 6.503776e+00  3.088555301
c(Industry)Auto & Truck Dealerships                                      1.921669e+01 6.617899e+00  2.903744489
c(Industry)Auto Manufacturers                                            1.670493e+01 6.849198e+00  2.438961294
c(Industry)Auto Parts                                                    2.011695e+01 6.540363e+00  3.075815569
c(Industry)Banks - Diversified                                           1.612714e+01 6.981378e+00  2.310022745
c(Industry)Banks - Regional                                              1.952694e+01 6.491398e+00  3.008125841
c(Industry)Beverages - Brewers                                           2.086074e+01 7.135627e+00  2.923462430
c(Industry)Beverages - Non-Alcoholic                                     1.588149e+01 6.668816e+00  2.381456179
c(Industry)Beverages - Wineries & Distilleries                           1.501220e+01 7.827290e+00  1.917930866
c(Industry)Biotechnology                                                 1.768441e+01 6.474630e+00  2.731338594
c(Industry)Broadcasting                                                  2.153236e+01 6.632099e+00  3.246688380
c(Industry)Building Materials                                            1.864640e+01 7.067884e+00  2.638186476
c(Industry)Building Products & Equipment                                 1.914115e+01 6.555648e+00  2.919795682
c(Industry)Business Equipment & Supplies                                 1.511786e+01 7.300092e+00  2.070913196
c(Industry)Capital Markets                                               1.860898e+01 6.636056e+00  2.804222430
c(Industry)Chemicals                                                     2.058289e+01 6.698412e+00  3.072801096
c(Industry)Coking Coal                                                   2.014108e+01 6.926850e+00  2.907683175
c(Industry)Communication Equipment                                       1.794202e+01 6.534046e+00  2.745927558
c(Industry)Computer Hardware                                             1.949671e+01 6.579174e+00  2.963398099
c(Industry)Confectioners                                                 1.851132e+01 7.185692e+00  2.576136473
c(Industry)Conglomerates                                                 1.838261e+01 6.607230e+00  2.782196028
c(Industry)Consulting Services                                           1.958518e+01 6.642924e+00  2.948276114
c(Industry)Consumer Electronics                                          1.895523e+01 6.805083e+00  2.785451858
c(Industry)Copper                                                        1.738987e+01 7.215429e+00  2.410095495
c(Industry)Credit Services                                               2.251814e+01 6.580874e+00  3.421755564
c(Industry)Department Stores                                             1.666775e+01 6.938939e+00  2.402060141
c(Industry)Diagnostics & Research                                        1.814351e+01 6.519023e+00  2.783164214
c(Industry)Discount Stores                                               1.680495e+01 6.655115e+00  2.525117696
c(Industry)Drug Manufacturers - General                                  1.798558e+01 6.631100e+00  2.712307422
c(Industry)Drug Manufacturers - Specialty & Generic                      1.722571e+01 6.528490e+00  2.638543946
c(Industry)Education & Training Services                                 1.982654e+01 6.639052e+00  2.986350374
c(Industry)Electrical Equipment & Parts                                  1.624622e+01 6.582537e+00  2.468078443
c(Industry)Electronic Components                                         1.926009e+01 6.560897e+00  2.935587791
c(Industry)Electronic Gaming & Multimedia                                2.344708e+01 7.302749e+00  3.210719040
c(Industry)Electronics & Computer Distribution                           2.110567e+01 6.788119e+00  3.109207812
c(Industry)Engineering & Construction                                    1.852586e+01 6.556397e+00  2.825615545
c(Industry)Entertainment                                                 1.887896e+01 6.596569e+00  2.861936225
c(Industry)Farm & Heavy Construction Machinery                           1.851262e+01 6.581842e+00  2.812680456
c(Industry)Farm Products                                                 1.550059e+01 6.693367e+00  2.315813582
c(Industry)Financial Conglomerates                                       2.181677e+01 7.235031e+00  3.015436008
c(Industry)Financial Data & Stock Exchanges                              1.750144e+01 6.670508e+00  2.623704357
c(Industry)Food Distribution                                             1.775426e+01 6.675468e+00  2.659627243
c(Industry)Footwear & Accessories                                        1.840003e+01 6.627786e+00  2.776196163
c(Industry)Furnishings, Fixtures & Appliances                            1.768820e+01 6.594783e+00  2.682150608
c(Industry)Gambling                                                      2.162362e+01 6.696621e+00  3.229034017
c(Industry)Gold                                                          1.887446e+01 6.786698e+00  2.781096211
c(Industry)Grocery Stores                                                1.985645e+01 6.750405e+00  2.941519552
c(Industry)Health Information Services                                   1.660209e+01 6.561682e+00  2.530157536
c(Industry)Healthcare Plans                                              1.837395e+01 6.679426e+00  2.750828251
c(Industry)Home Improvement Retail                                       1.877905e+01 6.801826e+00  2.760883214
c(Industry)Household & Personal Products                                 1.977695e+01 6.563333e+00  3.013248352
c(Industry)Industrial Distribution                                       1.904282e+01 6.604612e+00  2.883260835
c(Industry)Information Technology Services                               2.033555e+01 6.542534e+00  3.108206357
c(Industry)Infrastructure Operations                                     1.931645e+01 8.602088e+00  2.245553322
c(Industry)Insurance - Diversified                                       2.165922e+01 7.065240e+00  3.065602437
c(Industry)Insurance - Life                                              1.764955e+01 6.681431e+00  2.641582381
c(Industry)Insurance - Property & Casualty                               1.930833e+01 6.577541e+00  2.935493603
c(Industry)Insurance - Reinsurance                                       1.268552e+01 1.115650e+01  1.137051748
c(Industry)Insurance - Specialty                                         1.736502e+01 6.705883e+00  2.589520843
c(Industry)Insurance Brokers                                             1.416070e+01 6.768144e+00  2.092257197
c(Industry)Integrated Freight & Logistics                                1.964015e+01 6.641397e+00  2.957232324
c(Industry)Internet Content & Information                                2.149086e+01 6.585982e+00  3.263122540
c(Industry)Internet Retail                                               1.905648e+01 6.673163e+00  2.855689985
c(Industry)Leisure                                                       1.984655e+01 6.613617e+00  3.000861610
c(Industry)Lodging                                                       1.898925e+01 6.748197e+00  2.813974523
c(Industry)Lumber & Wood Production                                      1.970579e+01 7.008393e+00  2.811741630
c(Industry)Luxury Goods                                                  1.620376e+01 6.941688e+00  2.334267247
c(Industry)Marine Shipping                                               1.818305e+01 7.065573e+00  2.573472059
c(Industry)Medical Care Facilities                                       1.926648e+01 6.554778e+00  2.939302624
c(Industry)Medical Devices                                               1.770605e+01 6.507423e+00  2.720899933
c(Industry)Medical Distribution                                          1.748446e+01 6.668600e+00  2.621908497
c(Industry)Medical Instruments & Supplies                                1.824140e+01 6.528630e+00  2.794062373
c(Industry)Metal Fabrication                                             1.752813e+01 6.659787e+00  2.631935543
c(Industry)Mortgage Finance                                              1.951672e+01 6.843416e+00  2.851897944
c(Industry)Oil & Gas Drilling                                            1.858914e+01 7.708769e+00  2.411427852
c(Industry)Oil & Gas E&P                                                 1.900442e+01 6.566933e+00  2.893956445
c(Industry)Oil & Gas Equipment & Services                                1.760545e+01 6.544200e+00  2.690236934
c(Industry)Oil & Gas Integrated                                          1.853968e+01 7.123102e+00  2.602754199
c(Industry)Oil & Gas Midstream                                           1.850390e+01 6.605317e+00  2.801364445
c(Industry)Oil & Gas Refining & Marketing                                1.988788e+01 6.645362e+00  2.992746177
c(Industry)Other Industrial Metals & Mining                              1.632299e+01 7.658758e+00  2.131284749
c(Industry)Other Precious Metals & Mining                                2.166747e+01 7.648998e+00  2.832720361
c(Industry)Packaged Foods                                                1.803016e+01 6.526796e+00  2.762482552
c(Industry)Packaging & Containers                                        1.891135e+01 6.579495e+00  2.874286156
c(Industry)Paper & Paper Products                                        4.346957e+00 1.127403e+01  0.385572399
c(Industry)Personal Services                                             1.910966e+01 6.706652e+00  2.849359505
c(Industry)Pharmaceutical Retailers                                      1.599611e+01 7.335096e+00  2.180764099
c(Industry)Pollution & Treatment Controls                                1.880624e+01 6.898147e+00  2.726273575
c(Industry)Publishing                                                    1.919271e+01 6.907966e+00  2.778344827
c(Industry)Railroads                                                     1.920804e+01 6.723442e+00  2.856875801
c(Industry)Real Estate - Development                                     2.193352e+01 7.737740e+00  2.834615978
c(Industry)Real Estate - Diversified                                     1.905599e+01 7.909559e+00  2.409235752
c(Industry)Real Estate Services                                          2.042546e+01 6.644186e+00  3.074184940
c(Industry)Recreational Vehicles                                         1.811045e+01 6.708832e+00  2.699493785
c(Industry)REIT - Diversified                                            1.756257e+01 6.659156e+00  2.637356721
c(Industry)REIT - Healthcare Facilities                                  1.910997e+01 6.595709e+00  2.897334061
c(Industry)REIT - Hotel & Motel                                          1.853731e+01 6.582477e+00  2.816159697
c(Industry)REIT - Industrial                                             1.815525e+01 6.631414e+00  2.737764635
c(Industry)REIT - Mortgage                                               1.834583e+01 6.546556e+00  2.802363114
c(Industry)REIT - Office                                                 1.841960e+01 6.608928e+00  2.787078332
c(Industry)REIT - Residential                                            1.933413e+01 6.594612e+00  2.931806854
c(Industry)REIT - Retail                                                 1.927536e+01 6.588406e+00  2.925648562
c(Industry)REIT - Specialty                                              1.860423e+01 6.585487e+00  2.825035343
c(Industry)Rental & Leasing Services                                     1.815573e+01 6.648934e+00  2.730623414
c(Industry)Residential Construction                                      2.046259e+01 6.631333e+00  3.085743121
c(Industry)Resorts & Casinos                                             1.958711e+01 6.613964e+00  2.961478605
c(Industry)Restaurants                                                   2.045702e+01 6.540684e+00  3.127657339
c(Industry)Scientific & Technical Instruments                            1.777158e+01 6.582571e+00  2.699792763
c(Industry)Security & Protection Services                                1.552564e+01 6.700784e+00  2.316987998
c(Industry)Semiconductor Equipment & Materials                           1.885861e+01 6.538323e+00  2.884319219
c(Industry)Semiconductors                                                2.112073e+01 6.513846e+00  3.242435892
c(Industry)Software - Application                                        1.766350e+01 6.500155e+00  2.717397327
c(Industry)Software - Infrastructure                                     1.836905e+01 6.508310e+00  2.822400031
c(Industry)Solar                                                         2.162075e+01 6.849517e+00  3.156535716
c(Industry)Specialty Business Services                                   1.741142e+01 6.597695e+00  2.639014840
c(Industry)Specialty Chemicals                                           1.772000e+01 6.533476e+00  2.712184966
c(Industry)Specialty Industrial Machinery                                1.895555e+01 6.518641e+00  2.907898968
c(Industry)Specialty Retail                                              2.036143e+01 6.551431e+00  3.107936626
c(Industry)Staffing & Employment Services                                2.060825e+01 6.625427e+00  3.110479176
c(Industry)Steel                                                         2.001727e+01 6.706064e+00  2.984950079
c(Industry)Telecom Services                                              1.860766e+01 6.580116e+00  2.827861582
c(Industry)Textile Manufacturing                                         1.452279e+01 6.861682e+00  2.116506205
c(Industry)Thermal Coal                                                  1.849469e+01 6.826007e+00  2.709444607
c(Industry)Tobacco                                                       1.939233e+01 6.790650e+00  2.855739119
c(Industry)Tools & Accessories                                           1.762643e+01 6.663461e+00  2.645236743
c(Industry)Travel Services                                               1.866228e+01 6.652106e+00  2.805469067
c(Industry)Trucking                                                      1.997440e+01 6.824576e+00  2.926833553
c(Industry)Uranium                                                       1.080500e+01 7.749856e+00  1.394218891
c(Industry)Utilities - Diversified                                       1.857978e+01 6.894231e+00  2.694974907
c(Industry)Utilities - Independent Power Producers                       2.022584e+01 8.004847e+00  2.526699198
c(Industry)Utilities - Regulated Electric                                1.865808e+01 6.548475e+00  2.849224470
c(Industry)Utilities - Regulated Gas                                     1.956075e+01 6.660971e+00  2.936620932
c(Industry)Utilities - Regulated Water                                   1.978501e+01 6.907317e+00  2.864354841
c(Industry)Utilities - Renewable                                         1.934145e+01 8.013290e+00  2.413671240
c(Industry)Waste Management                                              1.827130e+01 6.658832e+00  2.743920046
c(Industry)Advertising Agencies:Covid_Net_Sentiment                      6.725509e-01 1.825314e+00  0.368457630
c(Industry)Aerospace & Defense:Covid_Net_Sentiment                       8.964646e-01 1.309372e+00  0.684652584
c(Industry)Agricultural Inputs:Covid_Net_Sentiment                       2.263819e+00 4.166881e+00  0.543288704
c(Industry)Airlines:Covid_Net_Sentiment                                  3.956423e+00 3.766572e+00  1.050404118
c(Industry)Airports & Air Services:Covid_Net_Sentiment                   2.381702e+01 2.010741e+01  1.184489695
c(Industry)Aluminum:Covid_Net_Sentiment                                  8.033514e-01 3.930851e+00  0.204370856
c(Industry)Apparel Manufacturing:Covid_Net_Sentiment                    -8.369934e-01 1.705216e+00 -0.490843135
c(Industry)Apparel Retail:Covid_Net_Sentiment                           -2.499407e+00 1.963080e+00 -1.273206786
c(Industry)Asset Management:Covid_Net_Sentiment                          2.064393e+00 1.025120e+00  2.013805222
c(Industry)Auto & Truck Dealerships:Covid_Net_Sentiment                 -5.772391e+00 2.668964e+00 -2.162783362
c(Industry)Auto Manufacturers:Covid_Net_Sentiment                       -7.155057e-01 6.154040e+00 -0.116266009
c(Industry)Auto Parts:Covid_Net_Sentiment                                7.726555e-01 1.054925e+00  0.732426707
c(Industry)Banks - Diversified:Covid_Net_Sentiment                       1.482074e+00 1.066969e+01  0.138905083
c(Industry)Banks - Regional:Covid_Net_Sentiment                          3.895815e-01 9.823412e-01  0.396584704
c(Industry)Beverages - Brewers:Covid_Net_Sentiment                       8.869658e+00 6.168455e+00  1.437905934
c(Industry)Beverages - Non-Alcoholic:Covid_Net_Sentiment                -1.306401e-01 2.176346e+00 -0.060027273
c(Industry)Beverages - Wineries & Distilleries:Covid_Net_Sentiment       2.462221e+00 9.629038e+00  0.255707915
c(Industry)Biotechnology:Covid_Net_Sentiment                             3.103947e-01 5.964029e-01  0.520444615
c(Industry)Broadcasting:Covid_Net_Sentiment                              4.776540e+00 2.191856e+00  2.179221693
c(Industry)Building Materials:Covid_Net_Sentiment                       -1.038180e+00 8.326409e+00 -0.124685183
c(Industry)Building Products & Equipment:Covid_Net_Sentiment             2.621179e-01 2.049949e+00  0.127865535
c(Industry)Business Equipment & Supplies:Covid_Net_Sentiment             2.364379e+00 6.868544e+00  0.344232982
c(Industry)Capital Markets:Covid_Net_Sentiment                           2.835836e+00 3.757020e+00  0.754809962
c(Industry)Chemicals:Covid_Net_Sentiment                                 3.231795e+00 1.801169e+00  1.794276215
c(Industry)Coking Coal:Covid_Net_Sentiment                               4.213311e+00 4.382415e+00  0.961413037
c(Industry)Communication Equipment:Covid_Net_Sentiment                   1.001880e+00 1.439051e+00  0.696208378
c(Industry)Computer Hardware:Covid_Net_Sentiment                        -1.521496e+00 1.525128e+00 -0.997618717
c(Industry)Confectioners:Covid_Net_Sentiment                             2.898352e+00 6.713534e+00  0.431717817
c(Industry)Conglomerates:Covid_Net_Sentiment                            -3.619833e-01 2.074003e+00 -0.174533634
c(Industry)Consulting Services:Covid_Net_Sentiment                       1.331599e+00 2.837290e+00  0.469320641
c(Industry)Consumer Electronics:Covid_Net_Sentiment                      9.464217e+00 3.593178e+00  2.633940571
c(Industry)Copper:Covid_Net_Sentiment                                   -5.449033e-01 7.248392e+00 -0.075175744
c(Industry)Credit Services:Covid_Net_Sentiment                           7.210379e-01 2.128680e+00  0.338725334
c(Industry)Department Stores:Covid_Net_Sentiment                        -3.159208e+00 5.970755e+00 -0.529113656
c(Industry)Diagnostics & Research:Covid_Net_Sentiment                    3.117489e-01 1.002728e+00  0.310900769
c(Industry)Discount Stores:Covid_Net_Sentiment                           1.735666e+01 3.861971e+00  4.494248469
c(Industry)Drug Manufacturers - General:Covid_Net_Sentiment             -1.325444e+00 2.436761e+00 -0.543936911
c(Industry)Drug Manufacturers - Specialty & Generic:Covid_Net_Sentiment -5.199854e-01 8.995517e-01 -0.578049527
c(Industry)Education & Training Services:Covid_Net_Sentiment             2.081421e-01 2.514741e+00  0.082768800
c(Industry)Electrical Equipment & Parts:Covid_Net_Sentiment              2.149634e+00 1.971581e+00  1.090309378
c(Industry)Electronic Components:Covid_Net_Sentiment                     3.186425e-01 1.227822e+00  0.259518563
c(Industry)Electronic Gaming & Multimedia:Covid_Net_Sentiment            9.837269e+00 2.028150e+01  0.485036550
c(Industry)Electronics & Computer Distribution:Covid_Net_Sentiment       4.244024e+00 3.030998e+00  1.400206781
c(Industry)Engineering & Construction:Covid_Net_Sentiment               -1.430404e+00 1.581058e+00 -0.904713017
c(Industry)Entertainment:Covid_Net_Sentiment                            -1.948726e-01 1.322225e+00 -0.147382324
c(Industry)Farm & Heavy Construction Machinery:Covid_Net_Sentiment      -5.017472e-01 1.893711e+00 -0.264954524
c(Industry)Farm Products:Covid_Net_Sentiment                            -5.861827e-01 3.112396e+00 -0.188338108
c(Industry)Financial Conglomerates:Covid_Net_Sentiment                   1.007588e+01 7.636365e+00  1.319460798
c(Industry)Financial Data & Stock Exchanges:Covid_Net_Sentiment         -8.888756e-01 5.298199e+00 -0.167769378
c(Industry)Food Distribution:Covid_Net_Sentiment                        -3.760603e-01 3.149177e+00 -0.119415417
c(Industry)Footwear & Accessories:Covid_Net_Sentiment                   -2.685429e-01 2.517627e+00 -0.106665106
c(Industry)Furnishings, Fixtures & Appliances:Covid_Net_Sentiment       -1.091046e+00 1.740516e+00 -0.626852372
c(Industry)Gambling:Covid_Net_Sentiment                                  5.111663e+00 3.758486e+00  1.360032656
c(Industry)Gold:Covid_Net_Sentiment                                      3.974303e+00 4.583313e+00  0.867124481
c(Industry)Grocery Stores:Covid_Net_Sentiment                           -9.148880e+00 4.030796e+00 -2.269745482
c(Industry)Health Information Services:Covid_Net_Sentiment              -2.935378e+00 1.775470e+00 -1.653296494
c(Industry)Healthcare Plans:Covid_Net_Sentiment                          1.716567e+00 2.621393e+00  0.654829946
c(Industry)Home Improvement Retail:Covid_Net_Sentiment                   9.568531e-01 2.260313e+00  0.423327744
c(Industry)Household & Personal Products:Covid_Net_Sentiment             4.046490e-01 1.644447e+00  0.246069892
c(Industry)Industrial Distribution:Covid_Net_Sentiment                  -5.812667e+00 2.453127e+00 -2.369493215
c(Industry)Information Technology Services:Covid_Net_Sentiment           2.555935e+00 1.831685e+00  1.395400498
c(Industry)Infrastructure Operations:Covid_Net_Sentiment                -2.852109e-01 8.237404e+00 -0.034623875
c(Industry)Insurance - Diversified:Covid_Net_Sentiment                   4.277110e+00 4.102927e+00  1.042453300
c(Industry)Insurance - Life:Covid_Net_Sentiment                         -4.603718e-02 1.150395e+00 -0.040018587
c(Industry)Insurance - Property & Casualty:Covid_Net_Sentiment           1.279216e+00 9.634062e-01  1.327805667
c(Industry)Insurance - Reinsurance:Covid_Net_Sentiment                  -3.972069e+00 4.244340e+00 -0.935850991
c(Industry)Insurance - Specialty:Covid_Net_Sentiment                     1.848568e+00 1.538274e+00  1.201716165
c(Industry)Insurance Brokers:Covid_Net_Sentiment                        -9.985894e-01 2.982241e+00 -0.334845342
c(Industry)Integrated Freight & Logistics:Covid_Net_Sentiment            8.088487e+00 3.076920e+00  2.628760900
c(Industry)Internet Content & Information:Covid_Net_Sentiment            1.975012e+00 2.677147e+00  0.737730383
c(Industry)Internet Retail:Covid_Net_Sentiment                          -1.507458e+00 3.118653e+00 -0.483368260
c(Industry)Leisure:Covid_Net_Sentiment                                   2.446550e+00 2.629393e+00  0.930462069
c(Industry)Lodging:Covid_Net_Sentiment                                  -6.225425e+00 3.368413e+00 -1.848177323
c(Industry)Lumber & Wood Production:Covid_Net_Sentiment                 -2.514615e+00 4.976108e+00 -0.505337628
c(Industry)Luxury Goods:Covid_Net_Sentiment                              4.834761e-01 4.354070e+00  0.111040042
c(Industry)Marine Shipping:Covid_Net_Sentiment                          -1.515307e+00 3.391450e+00 -0.446802147
c(Industry)Medical Care Facilities:Covid_Net_Sentiment                   1.276612e+00 8.975489e-01  1.422331178
c(Industry)Medical Devices:Covid_Net_Sentiment                           1.265179e+00 5.971513e-01  2.118690098
c(Industry)Medical Distribution:Covid_Net_Sentiment                     -1.772505e-01 2.818390e+00 -0.062890712
c(Industry)Medical Instruments & Supplies:Covid_Net_Sentiment            6.883875e-01 9.746950e-01  0.706259393
c(Industry)Metal Fabrication:Covid_Net_Sentiment                         1.097564e+00 1.835692e+00  0.597901893
c(Industry)Mortgage Finance:Covid_Net_Sentiment                          8.061598e-01 2.828682e+00  0.284994816
c(Industry)Oil & Gas Drilling:Covid_Net_Sentiment                       -9.015285e-01 5.019916e+00 -0.179590359
c(Industry)Oil & Gas E&P:Covid_Net_Sentiment                            -5.251194e-01 2.721354e+00 -0.192962585
c(Industry)Oil & Gas Equipment & Services:Covid_Net_Sentiment           -2.037707e-02 1.169100e+00 -0.017429701
c(Industry)Oil & Gas Integrated:Covid_Net_Sentiment                      3.716720e+00 6.120732e+00  0.607234613
c(Industry)Oil & Gas Midstream:Covid_Net_Sentiment                      -1.947376e-01 2.198124e+00 -0.088592637
c(Industry)Oil & Gas Refining & Marketing:Covid_Net_Sentiment            1.816068e+00 2.820320e+00  0.643922706
c(Industry)Other Industrial Metals & Mining:Covid_Net_Sentiment         -3.568368e+00 7.854763e+00 -0.454293478
c(Industry)Other Precious Metals & Mining:Covid_Net_Sentiment           -3.198266e-01 1.082735e+01 -0.029538786
c(Industry)Packaged Foods:Covid_Net_Sentiment                            2.479688e+00 1.279788e+00  1.937577847
c(Industry)Packaging & Containers:Covid_Net_Sentiment                   -3.809013e-01 3.213441e+00 -0.118533758
c(Industry)Paper & Paper Products:Covid_Net_Sentiment                   -1.231426e+01 1.810663e+01 -0.680096893
c(Industry)Personal Services:Covid_Net_Sentiment                         6.955890e-01 2.870816e+00  0.242296575
c(Industry)Pharmaceutical Retailers:Covid_Net_Sentiment                 -1.672664e+00 4.080030e+00 -0.409963728
c(Industry)Pollution & Treatment Controls:Covid_Net_Sentiment           -1.535326e+00 4.239088e+00 -0.362183121
c(Industry)Publishing:Covid_Net_Sentiment                                7.101992e-01 2.095048e+00  0.338989471
c(Industry)Railroads:Covid_Net_Sentiment                                 1.146206e+00 4.395625e+00  0.260760613
c(Industry)Real Estate - Development:Covid_Net_Sentiment                 2.466398e+00 8.254987e+00  0.298776706
c(Industry)Real Estate - Diversified:Covid_Net_Sentiment                 2.951464e+00 6.691138e+00  0.441100478
c(Industry)Real Estate Services:Covid_Net_Sentiment                      3.670814e-01 2.926053e+00  0.125452733
c(Industry)Recreational Vehicles:Covid_Net_Sentiment                    -1.466607e+00 3.099722e+00 -0.473141323
c(Industry)REIT - Diversified:Covid_Net_Sentiment                        1.762709e+00 3.230700e+00  0.545612149
c(Industry)REIT - Healthcare Facilities:Covid_Net_Sentiment              1.592130e+00 2.383924e+00  0.667860986
c(Industry)REIT - Hotel & Motel:Covid_Net_Sentiment                      5.880653e+00 2.743703e+00  2.143326937
c(Industry)REIT - Industrial:Covid_Net_Sentiment                        -6.386170e-01 4.211767e+00 -0.151626856
c(Industry)REIT - Mortgage:Covid_Net_Sentiment                           4.097220e-01 1.298274e+00  0.315589715
c(Industry)REIT - Office:Covid_Net_Sentiment                             3.960797e+00 3.069770e+00  1.290258572
c(Industry)REIT - Residential:Covid_Net_Sentiment                        1.123781e+00 3.344137e+00  0.336045234
c(Industry)REIT - Retail:Covid_Net_Sentiment                            -1.267943e+00 2.388916e+00 -0.530760614
c(Industry)REIT - Specialty:Covid_Net_Sentiment                          9.137897e-01 2.130464e+00  0.428915852
c(Industry)Rental & Leasing Services:Covid_Net_Sentiment                 5.919049e-01 2.450024e+00  0.241591448
c(Industry)Residential Construction:Covid_Net_Sentiment                 -8.313152e-01 1.730470e+00 -0.480398513
c(Industry)Resorts & Casinos:Covid_Net_Sentiment                         9.458729e-01 2.560434e+00  0.369418957
c(Industry)Restaurants:Covid_Net_Sentiment                               1.774190e+00 1.638654e+00  1.082712001
c(Industry)Scientific & Technical Instruments:Covid_Net_Sentiment       -2.122107e-01 1.933490e+00 -0.109755257
c(Industry)Security & Protection Services:Covid_Net_Sentiment           -1.747377e+00 2.730656e+00 -0.639911067
c(Industry)Semiconductor Equipment & Materials:Covid_Net_Sentiment       8.564378e-01 2.043402e+00  0.419123481
c(Industry)Semiconductors:Covid_Net_Sentiment                            3.992987e+00 1.767990e+00  2.258489759
c(Industry)Software - Application:Covid_Net_Sentiment                   -6.093691e-01 9.866973e-01 -0.617584656
c(Industry)Software - Infrastructure:Covid_Net_Sentiment                 2.864049e+00 1.316849e+00  2.174925601
c(Industry)Solar:Covid_Net_Sentiment                                     4.942293e+00 8.111415e+00  0.609300966
c(Industry)Specialty Business Services:Covid_Net_Sentiment               2.744538e+00 1.829250e+00  1.500362567
c(Industry)Specialty Chemicals:Covid_Net_Sentiment                       7.103789e-02 1.342977e+00  0.052895837
c(Industry)Specialty Industrial Machinery:Covid_Net_Sentiment            7.598497e-01 1.156065e+00  0.657272630
c(Industry)Specialty Retail:Covid_Net_Sentiment                          2.999486e+00 1.737906e+00  1.725919973
c(Industry)Staffing & Employment Services:Covid_Net_Sentiment            9.052833e-01 1.759231e+00  0.514590250
c(Industry)Steel:Covid_Net_Sentiment                                     5.645411e-01 3.318966e+00  0.170095490
c(Industry)Telecom Services:Covid_Net_Sentiment                          2.271473e+00 1.993905e+00  1.139207975
c(Industry)Textile Manufacturing:Covid_Net_Sentiment                     3.605093e-03 2.447776e+00  0.001472803
c(Industry)Thermal Coal:Covid_Net_Sentiment                             -5.328910e-02 2.267514e+00 -0.023501111
c(Industry)Tobacco:Covid_Net_Sentiment                                  -4.185579e+00 2.415877e+00 -1.732529395
c(Industry)Tools & Accessories:Covid_Net_Sentiment                      -7.325023e-01 2.369622e+00 -0.309122058
c(Industry)Travel Services:Covid_Net_Sentiment                           1.811519e+00 3.708809e+00  0.488436874
c(Industry)Trucking:Covid_Net_Sentiment                                  5.764375e+00 8.924307e+00  0.645918434
c(Industry)Uranium:Covid_Net_Sentiment                                   4.494686e-01 4.843891e+00  0.092790826
c(Industry)Utilities - Diversified:Covid_Net_Sentiment                   1.422333e+00 1.982309e+00  0.717513176
c(Industry)Utilities - Independent Power Producers:Covid_Net_Sentiment   3.319414e+00 7.022029e+00  0.472714382
c(Industry)Utilities - Regulated Electric:Covid_Net_Sentiment            8.479670e-01 1.822268e+00  0.465336046
c(Industry)Utilities - Regulated Gas:Covid_Net_Sentiment                 1.043379e+00 2.344847e+00  0.444966799
c(Industry)Utilities - Regulated Water:Covid_Net_Sentiment               1.709661e+00 3.259025e+00  0.524592941
c(Industry)Utilities - Renewable:Covid_Net_Sentiment                     4.718024e-01 4.132892e+00  0.114157923
c(Industry)Waste Management:Covid_Net_Sentiment                         -9.952867e-01 2.676654e+00 -0.371839838

PercentChange_NegCOVIDSentiment_SharePrices_HierchicalIndustryCompany <- glmer(
  "Percent_Change_bt_DayBefore_y_DayAfter ~ -1 + Day_of_EarningsCall + c(Industry) + Covid_Neg_Sentiment:c(Industry) + (1 | company_name)", 
  data=Closing_Share_Price_Across_Time,
  family=gaussian) 
Warning: calling glmer() with family=gaussian (identity link) as a shortcut to lmer() is deprecated; please call lmer() directlyWarning: Some predictor variables are on very different scales: consider rescaling
summary(PercentChange_NegCOVIDSentiment_SharePrices_HierchicalIndustryCompany)$coefficients  
                                                                             Estimate   Std. Error      t value
Day_of_EarningsCall                                                     -9.125566e-04 3.532578e-04 -2.583259181
c(Industry)Advertising Agencies                                          1.581991e+01 6.823696e+00  2.318378507
c(Industry)Aerospace & Defense                                           1.643351e+01 6.714109e+00  2.447607944
c(Industry)Agricultural Inputs                                           1.947434e+01 7.112361e+00  2.738097920
c(Industry)Airlines                                                      1.793121e+01 6.850120e+00  2.617649428
c(Industry)Airports & Air Services                                       1.291724e+01 9.997372e+00  1.292063778
c(Industry)Aluminum                                                      1.491566e+01 7.763897e+00  1.921156478
c(Industry)Apparel Manufacturing                                         1.862356e+01 6.785800e+00  2.744489719
c(Industry)Apparel Retail                                                1.739447e+01 6.744399e+00  2.579098390
c(Industry)Asset Management                                              1.903779e+01 6.653966e+00  2.861119218
c(Industry)Auto & Truck Dealerships                                      1.781741e+01 6.820732e+00  2.612243160
c(Industry)Auto Manufacturers                                            1.477265e+01 7.382957e+00  2.000913160
c(Industry)Auto Parts                                                    1.892342e+01 6.669309e+00  2.837388948
c(Industry)Banks - Diversified                                           1.589170e+01 7.408433e+00  2.145082413
c(Industry)Banks - Regional                                              1.849426e+01 6.632570e+00  2.788400812
c(Industry)Beverages - Brewers                                           1.960939e+01 7.688561e+00  2.550462724
c(Industry)Beverages - Non-Alcoholic                                     1.528032e+01 6.996790e+00  2.183904930
c(Industry)Beverages - Wineries & Distilleries                           1.599694e+01 8.915132e+00  1.794358463
c(Industry)Biotechnology                                                 1.730096e+01 6.607281e+00  2.618468553
c(Industry)Broadcasting                                                  2.205686e+01 6.831307e+00  3.228790177
c(Industry)Building Materials                                            1.875138e+01 7.317862e+00  2.562412206
c(Industry)Building Products & Equipment                                 1.716321e+01 6.723575e+00  2.552691550
c(Industry)Business Equipment & Supplies                                 1.183315e+01 8.604327e+00  1.375255783
c(Industry)Capital Markets                                               1.840211e+01 6.864348e+00  2.680824217
c(Industry)Chemicals                                                     1.971288e+01 6.867359e+00  2.870517956
c(Industry)Coking Coal                                                   2.015863e+01 7.233789e+00  2.786731491
c(Industry)Communication Equipment                                       1.660323e+01 6.691741e+00  2.481151981
c(Industry)Computer Hardware                                             1.740227e+01 6.773493e+00  2.569171696
c(Industry)Confectioners                                                 1.698302e+01 8.450469e+00  2.009713640
c(Industry)Conglomerates                                                 1.611918e+01 6.848411e+00  2.353710316
c(Industry)Consulting Services                                           1.989314e+01 6.921811e+00  2.873978569
c(Industry)Consumer Electronics                                          1.790023e+01 7.208310e+00  2.483277408
c(Industry)Copper                                                        1.585411e+01 8.351596e+00  1.898332436
c(Industry)Credit Services                                               2.095593e+01 6.771731e+00  3.094619172
c(Industry)Department Stores                                             1.799901e+01 7.283511e+00  2.471199668
c(Industry)Diagnostics & Research                                        1.694168e+01 6.696644e+00  2.529875326
c(Industry)Discount Stores                                               2.121945e+01 6.866065e+00  3.090482429
c(Industry)Drug Manufacturers - General                                  1.643296e+01 6.906701e+00  2.379277190
c(Industry)Drug Manufacturers - Specialty & Generic                      1.596697e+01 6.704614e+00  2.381490144
c(Industry)Education & Training Services                                 1.850040e+01 6.846854e+00  2.702029572
c(Industry)Electrical Equipment & Parts                                  1.535088e+01 6.789610e+00  2.260936662
c(Industry)Electronic Components                                         1.857472e+01 6.731516e+00  2.759365661
c(Industry)Electronic Gaming & Multimedia                                2.475561e+01 8.300785e+00  2.982321605
c(Industry)Electronics & Computer Distribution                           2.015374e+01 7.073556e+00  2.849166271
c(Industry)Engineering & Construction                                    1.726496e+01 6.738135e+00  2.562275163
c(Industry)Entertainment                                                 1.750388e+01 6.748611e+00  2.593701110
c(Industry)Farm & Heavy Construction Machinery                           1.746558e+01 6.772360e+00  2.578950788
c(Industry)Farm Products                                                 1.330584e+01 6.933063e+00  1.919186501
c(Industry)Financial Conglomerates                                       1.983691e+01 8.103775e+00  2.447860976
c(Industry)Financial Data & Stock Exchanges                              1.557975e+01 6.907748e+00  2.255401402
c(Industry)Food Distribution                                             1.572314e+01 7.014472e+00  2.241528670
c(Industry)Footwear & Accessories                                        1.411002e+01 6.891067e+00  2.047582071
c(Industry)Furnishings, Fixtures & Appliances                            1.533445e+01 6.816689e+00  2.249544933
c(Industry)Gambling                                                      2.139822e+01 7.039453e+00  3.039756454
c(Industry)Gold                                                          1.954244e+01 7.273979e+00  2.686622891
c(Industry)Grocery Stores                                                1.321273e+01 7.173007e+00  1.842007695
c(Industry)Health Information Services                                   1.490812e+01 6.749486e+00  2.208778151
c(Industry)Healthcare Plans                                              1.718606e+01 7.105216e+00  2.418795390
c(Industry)Home Improvement Retail                                       1.846419e+01 7.044031e+00  2.621253946
c(Industry)Household & Personal Products                                 1.843306e+01 6.778236e+00  2.719448614
c(Industry)Industrial Distribution                                       1.691845e+01 6.811929e+00  2.483650272
c(Industry)Information Technology Services                               1.851004e+01 6.716066e+00  2.756083901
c(Industry)Infrastructure Operations                                     1.804143e+01 1.179459e+01  1.529636102
c(Industry)Insurance - Diversified                                       2.087750e+01 7.364349e+00  2.834941828
c(Industry)Insurance - Life                                              1.691354e+01 6.950152e+00  2.433548945
c(Industry)Insurance - Property & Casualty                               1.779553e+01 6.725477e+00  2.645988407
c(Industry)Insurance - Reinsurance                                       3.852519e+00 1.508318e+01  0.255418268
c(Industry)Insurance - Specialty                                         1.669864e+01 6.901259e+00  2.419650764
c(Industry)Insurance Brokers                                             1.161694e+01 6.967680e+00  1.667260487
c(Industry)Integrated Freight & Logistics                                1.941137e+01 6.828363e+00  2.842756144
c(Industry)Internet Content & Information                                1.913574e+01 6.803530e+00  2.812618790
c(Industry)Internet Retail                                               1.707890e+01 6.853243e+00  2.492089782
c(Industry)Leisure                                                       1.861662e+01 6.873282e+00  2.708548444
c(Industry)Lodging                                                       1.591779e+01 7.069127e+00  2.251734112
c(Industry)Lumber & Wood Production                                      2.085461e+01 7.697852e+00  2.709146232
c(Industry)Luxury Goods                                                  1.924226e+01 7.512218e+00  2.561461654
c(Industry)Marine Shipping                                               1.702004e+01 7.381955e+00  2.305627028
c(Industry)Medical Care Facilities                                       1.764509e+01 6.731021e+00  2.621458439
c(Industry)Medical Devices                                               1.704029e+01 6.648654e+00  2.562967786
c(Industry)Medical Distribution                                          1.611911e+01 6.969814e+00  2.312703267
c(Industry)Medical Instruments & Supplies                                1.763533e+01 6.713029e+00  2.627030747
c(Industry)Metal Fabrication                                             1.642300e+01 6.920523e+00  2.373085900
c(Industry)Mortgage Finance                                              1.786403e+01 7.083547e+00  2.521904492
c(Industry)Oil & Gas Drilling                                            1.811816e+01 8.473194e+00  2.138291712
c(Industry)Oil & Gas E&P                                                 1.855967e+01 6.745087e+00  2.751583748
c(Industry)Oil & Gas Equipment & Services                                1.643645e+01 6.676429e+00  2.461862132
c(Industry)Oil & Gas Integrated                                          1.800329e+01 7.478294e+00  2.407406274
c(Industry)Oil & Gas Midstream                                           1.733924e+01 6.781248e+00  2.556939950
c(Industry)Oil & Gas Refining & Marketing                                1.794876e+01 6.857787e+00  2.617281715
c(Industry)Other Industrial Metals & Mining                              1.243868e+01 8.306194e+00  1.497518662
c(Industry)Other Precious Metals & Mining                                2.244570e+01 8.768843e+00  2.559710142
c(Industry)Packaged Foods                                                1.773565e+01 6.696416e+00  2.648528882
c(Industry)Packaging & Containers                                        1.824491e+01 6.788106e+00  2.687775872
c(Industry)Paper & Paper Products                                        8.894955e+00 1.410755e+01  0.630510311
c(Industry)Personal Services                                             1.623107e+01 6.986694e+00  2.323139791
c(Industry)Pharmaceutical Retailers                                      1.333488e+01 7.933769e+00  1.680774894
c(Industry)Pollution & Treatment Controls                                1.824803e+01 7.225041e+00  2.525664392
c(Industry)Publishing                                                    1.839758e+01 7.124532e+00  2.582286118
c(Industry)Railroads                                                     1.881573e+01 6.989756e+00  2.691900325
c(Industry)Real Estate - Development                                     1.911294e+01 8.089191e+00  2.362775790
c(Industry)Real Estate - Diversified                                     1.644478e+01 9.807927e+00  1.676682714
c(Industry)Real Estate Services                                          1.906833e+01 6.799893e+00  2.804210003
c(Industry)Recreational Vehicles                                         1.511916e+01 6.959750e+00  2.172371372
c(Industry)REIT - Diversified                                            1.626432e+01 6.926068e+00  2.348276333
c(Industry)REIT - Healthcare Facilities                                  1.649004e+01 6.973026e+00  2.364832812
c(Industry)REIT - Hotel & Motel                                          1.850899e+01 6.791982e+00  2.725124017
c(Industry)REIT - Industrial                                             1.622019e+01 6.888764e+00  2.354585854
c(Industry)REIT - Mortgage                                               1.706531e+01 6.694636e+00  2.549102780
c(Industry)REIT - Office                                                 1.765562e+01 6.844426e+00  2.579562275
c(Industry)REIT - Residential                                            1.735160e+01 6.860951e+00  2.529036668
c(Industry)REIT - Retail                                                 1.806404e+01 6.807634e+00  2.653496791
c(Industry)REIT - Specialty                                              1.728656e+01 6.817435e+00  2.535639534
c(Industry)Rental & Leasing Services                                     1.747225e+01 6.848569e+00  2.551227094
c(Industry)Residential Construction                                      1.870448e+01 6.783041e+00  2.757536482
c(Industry)Resorts & Casinos                                             1.780847e+01 6.824308e+00  2.609563522
c(Industry)Restaurants                                                   1.955912e+01 6.718470e+00  2.911246007
c(Industry)Scientific & Technical Instruments                            1.648038e+01 6.774914e+00  2.432558523
c(Industry)Security & Protection Services                                1.309123e+01 6.947437e+00  1.884325344
c(Industry)Semiconductor Equipment & Materials                           1.685799e+01 6.723666e+00  2.507261565
c(Industry)Semiconductors                                                2.119169e+01 6.692490e+00  3.166487911
c(Industry)Software - Application                                        1.619738e+01 6.638994e+00  2.439734580
c(Industry)Software - Infrastructure                                     1.746932e+01 6.667487e+00  2.620075139
c(Industry)Solar                                                         1.555348e+01 7.412725e+00  2.098213213
c(Industry)Specialty Business Services                                   1.662499e+01 6.794792e+00  2.446725581
c(Industry)Specialty Chemicals                                           1.673048e+01 6.703797e+00  2.495671785
c(Industry)Specialty Industrial Machinery                                1.718071e+01 6.672844e+00  2.574721448
c(Industry)Specialty Retail                                              1.882216e+01 6.708322e+00  2.805792750
c(Industry)Staffing & Employment Services                                1.987398e+01 6.832302e+00  2.908826213
c(Industry)Steel                                                         1.908320e+01 6.950401e+00  2.745625753
c(Industry)Telecom Services                                              1.770717e+01 6.774221e+00  2.613905492
c(Industry)Textile Manufacturing                                         1.587100e+01 7.141591e+00  2.222333880
c(Industry)Thermal Coal                                                  1.780263e+01 7.081852e+00  2.513837869
c(Industry)Tobacco                                                       1.902802e+01 7.031681e+00  2.706041703
c(Industry)Tools & Accessories                                           1.585688e+01 6.873676e+00  2.306898915
c(Industry)Travel Services                                               1.815517e+01 6.919585e+00  2.623737462
c(Industry)Trucking                                                      2.076084e+01 7.164421e+00  2.897769542
c(Industry)Uranium                                                       6.825870e+00 9.297073e+00  0.734195533
c(Industry)Utilities - Diversified                                       1.807569e+01 7.138843e+00  2.532019575
c(Industry)Utilities - Independent Power Producers                       2.078844e+01 8.616578e+00  2.412610078
c(Industry)Utilities - Regulated Electric                                1.706224e+01 6.737087e+00  2.532584242
c(Industry)Utilities - Regulated Gas                                     1.867529e+01 6.985937e+00  2.673269431
c(Industry)Utilities - Regulated Water                                   1.853794e+01 7.281199e+00  2.546001106
c(Industry)Utilities - Renewable                                         1.989084e+01 8.592535e+00  2.314897562
c(Industry)Waste Management                                              1.691186e+01 6.983836e+00  2.421571811
c(Industry)Advertising Agencies:Covid_Neg_Sentiment                      7.537700e-01 2.268365e+00  0.332296595
c(Industry)Aerospace & Defense:Covid_Neg_Sentiment                       1.081201e-01 1.448569e+00  0.074639258
c(Industry)Agricultural Inputs:Covid_Neg_Sentiment                      -4.433597e+00 5.097316e+00 -0.869790402
c(Industry)Airlines:Covid_Neg_Sentiment                                 -4.710300e+00 4.217007e+00 -1.116976869
c(Industry)Airports & Air Services:Covid_Neg_Sentiment                  -1.462632e+00 7.601850e+00 -0.192404787
c(Industry)Aluminum:Covid_Neg_Sentiment                                 -4.213248e-01 3.780781e+00 -0.111438549
c(Industry)Apparel Manufacturing:Covid_Neg_Sentiment                    -2.004767e+00 1.568823e+00 -1.277879092
c(Industry)Apparel Retail:Covid_Neg_Sentiment                            3.952704e+00 1.969132e+00  2.007332888
c(Industry)Asset Management:Covid_Neg_Sentiment                         -1.182657e+00 1.156672e+00 -1.022464694
c(Industry)Auto & Truck Dealerships:Covid_Neg_Sentiment                  3.121857e+00 2.551884e+00  1.223353824
c(Industry)Auto Manufacturers:Covid_Neg_Sentiment                        2.641805e+00 8.275802e+00  0.319220373
c(Industry)Auto Parts:Covid_Neg_Sentiment                               -3.838040e-01 7.319240e-01 -0.524376833
c(Industry)Banks - Diversified:Covid_Neg_Sentiment                      -4.755204e+00 1.050390e+01 -0.452708410
c(Industry)Banks - Regional:Covid_Neg_Sentiment                         -5.874371e-01 1.034332e+00 -0.567938564
c(Industry)Beverages - Brewers:Covid_Neg_Sentiment                      -3.945834e+00 5.145012e+00 -0.766924093
c(Industry)Beverages - Non-Alcoholic:Covid_Neg_Sentiment                -7.619962e-01 2.239198e+00 -0.340298800
c(Industry)Beverages - Wineries & Distilleries:Covid_Neg_Sentiment      -6.857085e+00 1.182518e+01 -0.579871298
c(Industry)Biotechnology:Covid_Neg_Sentiment                            -1.405401e+00 6.293385e-01 -2.233139816
c(Industry)Broadcasting:Covid_Neg_Sentiment                             -5.626104e+00 2.230966e+00 -2.521824217
c(Industry)Building Materials:Covid_Neg_Sentiment                       -2.826774e+00 6.073858e+00 -0.465400081
c(Industry)Building Products & Equipment:Covid_Neg_Sentiment             1.619084e+00 1.909685e+00  0.847827819
c(Industry)Business Equipment & Supplies:Covid_Neg_Sentiment             2.350370e+00 7.781753e+00  0.302036009
c(Industry)Capital Markets:Covid_Neg_Sentiment                          -4.538883e+00 4.344275e+00 -1.044796449
c(Industry)Chemicals:Covid_Neg_Sentiment                                -2.003859e+00 1.495789e+00 -1.339666405
c(Industry)Coking Coal:Covid_Neg_Sentiment                              -4.893606e+00 4.214035e+00 -1.161263855
c(Industry)Communication Equipment:Covid_Neg_Sentiment                  -2.050410e-01 1.347135e+00 -0.152205249
c(Industry)Computer Hardware:Covid_Neg_Sentiment                         2.019621e+00 1.680483e+00  1.201809839
c(Industry)Confectioners:Covid_Neg_Sentiment                             1.090414e+00 5.744612e+00  0.189815090
c(Industry)Conglomerates:Covid_Neg_Sentiment                             2.065519e+00 2.340276e+00  0.882596424
c(Industry)Consulting Services:Covid_Neg_Sentiment                      -3.101361e+00 2.587062e+00 -1.198796416
c(Industry)Consumer Electronics:Covid_Neg_Sentiment                     -4.993997e+00 4.141532e+00 -1.205833415
c(Industry)Copper:Covid_Neg_Sentiment                                    8.807048e-01 8.330908e+00  0.105715339
c(Industry)Credit Services:Covid_Neg_Sentiment                           3.816238e-01 2.053568e+00  0.185834524
c(Industry)Department Stores:Covid_Neg_Sentiment                        -9.111772e+00 6.746381e+00 -1.350616221
c(Industry)Diagnostics & Research:Covid_Neg_Sentiment                    2.624229e-02 1.014743e+00  0.025861011
c(Industry)Discount Stores:Covid_Neg_Sentiment                          -2.202001e+01 4.217391e+00 -5.221240711
c(Industry)Drug Manufacturers - General:Covid_Neg_Sentiment              3.397052e-01 1.717106e+00  0.197835919
c(Industry)Drug Manufacturers - Specialty & Generic:Covid_Neg_Sentiment  1.483133e-01 9.639455e-01  0.153860644
c(Industry)Education & Training Services:Covid_Neg_Sentiment             1.804656e-01 2.236415e+00  0.080694134
c(Industry)Electrical Equipment & Parts:Covid_Neg_Sentiment             -1.395674e+00 1.748179e+00 -0.798358548
c(Industry)Electronic Components:Covid_Neg_Sentiment                    -7.958339e-01 1.100720e+00 -0.723011949
c(Industry)Electronic Gaming & Multimedia:Covid_Neg_Sentiment           -1.487273e+01 2.445770e+01 -0.608100159
c(Industry)Electronics & Computer Distribution:Covid_Neg_Sentiment      -2.429280e+00 3.107036e+00 -0.781864360
c(Industry)Engineering & Construction:Covid_Neg_Sentiment                6.531464e-01 1.489058e+00  0.438630512
c(Industry)Entertainment:Covid_Neg_Sentiment                             3.308875e-01 1.112673e+00  0.297380620
c(Industry)Farm & Heavy Construction Machinery:Covid_Neg_Sentiment       1.673038e-02 1.649910e+00  0.010140175
c(Industry)Farm Products:Covid_Neg_Sentiment                             2.031004e+00 2.462976e+00  0.824613754
c(Industry)Financial Conglomerates:Covid_Neg_Sentiment                  -2.055310e+00 6.581939e+00 -0.312265036
c(Industry)Financial Data & Stock Exchanges:Covid_Neg_Sentiment          3.023181e+00 4.961057e+00  0.609382323
c(Industry)Food Distribution:Covid_Neg_Sentiment                         1.964759e+00 3.802682e+00  0.516677178
c(Industry)Footwear & Accessories:Covid_Neg_Sentiment                    5.952979e+00 2.798204e+00  2.127428634
c(Industry)Furnishings, Fixtures & Appliances:Covid_Neg_Sentiment        2.186055e+00 1.690855e+00  1.292870006
c(Industry)Gambling:Covid_Neg_Sentiment                                 -3.534370e+00 4.779060e+00 -0.739553301
c(Industry)Gold:Covid_Neg_Sentiment                                     -4.909190e+00 5.516655e+00 -0.889885134
c(Industry)Grocery Stores:Covid_Neg_Sentiment                            1.418925e+01 5.271235e+00  2.691825991
c(Industry)Health Information Services:Covid_Neg_Sentiment               1.536520e+00 1.697142e+00  0.905357221
c(Industry)Healthcare Plans:Covid_Neg_Sentiment                         -3.601212e-01 2.847804e+00 -0.126455730
c(Industry)Home Improvement Retail:Covid_Neg_Sentiment                  -1.991008e+00 2.510390e+00 -0.793106777
c(Industry)Household & Personal Products:Covid_Neg_Sentiment             1.081211e-01 1.913306e+00  0.056510121
c(Industry)Industrial Distribution:Covid_Neg_Sentiment                   3.946124e+00 2.132064e+00  1.850846609
c(Industry)Information Technology Services:Covid_Neg_Sentiment           6.636625e-01 1.617006e+00  0.410426787
c(Industry)Infrastructure Operations:Covid_Neg_Sentiment                 2.164067e-01 1.000264e+01  0.021634966
c(Industry)Insurance - Diversified:Covid_Neg_Sentiment                  -2.538516e+00 2.902979e+00 -0.874452061
c(Industry)Insurance - Life:Covid_Neg_Sentiment                         -3.420084e-01 1.340297e+00 -0.255173603
c(Industry)Insurance - Property & Casualty:Covid_Neg_Sentiment          -5.193466e-01 8.230004e-01 -0.631040541
c(Industry)Insurance - Reinsurance:Covid_Neg_Sentiment                   4.720957e+00 4.032274e+00  1.170792721
c(Industry)Insurance - Specialty:Covid_Neg_Sentiment                    -1.806289e+00 1.495084e+00 -1.208151817
c(Industry)Insurance Brokers:Covid_Neg_Sentiment                         2.613708e+00 2.303617e+00  1.134610862
c(Industry)Integrated Freight & Logistics:Covid_Neg_Sentiment           -6.036541e+00 2.788913e+00 -2.164478176
c(Industry)Internet Content & Information:Covid_Neg_Sentiment            2.819344e+00 2.799508e+00  1.007085586
c(Industry)Internet Retail:Covid_Neg_Sentiment                           2.100083e+00 2.173654e+00  0.966153264
c(Industry)Leisure:Covid_Neg_Sentiment                                  -7.858691e-01 2.695943e+00 -0.291500573
c(Industry)Lodging:Covid_Neg_Sentiment                                   7.340518e+00 4.106654e+00  1.787469484
c(Industry)Lumber & Wood Production:Covid_Neg_Sentiment                 -4.325816e+00 6.069898e+00 -0.712667063
c(Industry)Luxury Goods:Covid_Neg_Sentiment                             -1.048368e+01 6.406558e+00 -1.636398278
c(Industry)Marine Shipping:Covid_Neg_Sentiment                           8.992648e-01 2.965463e+00  0.303245996
c(Industry)Medical Care Facilities:Covid_Neg_Sentiment                   1.192409e-01 9.455845e-01  0.126102895
c(Industry)Medical Devices:Covid_Neg_Sentiment                          -9.759346e-01 6.137219e-01 -1.590190329
c(Industry)Medical Distribution:Covid_Neg_Sentiment                      3.096189e-01 2.756344e+00  0.112329566
c(Industry)Medical Instruments & Supplies:Covid_Neg_Sentiment           -8.431923e-01 1.060904e+00 -0.794786427
c(Industry)Metal Fabrication:Covid_Neg_Sentiment                        -7.412691e-01 1.905868e+00 -0.388940322
c(Industry)Mortgage Finance:Covid_Neg_Sentiment                          9.716663e-02 2.427294e+00  0.040030848
c(Industry)Oil & Gas Drilling:Covid_Neg_Sentiment                       -2.618238e-01 4.791660e+00 -0.054641563
c(Industry)Oil & Gas E&P:Covid_Neg_Sentiment                            -1.719068e+00 2.676224e+00 -0.642348398
c(Industry)Oil & Gas Equipment & Services:Covid_Neg_Sentiment           -3.818971e-02 1.123217e+00 -0.034000312
c(Industry)Oil & Gas Integrated:Covid_Neg_Sentiment                     -4.327396e+00 7.096560e+00 -0.609787875
c(Industry)Oil & Gas Midstream:Covid_Neg_Sentiment                       4.319112e-02 2.390912e+00  0.018064709
c(Industry)Oil & Gas Refining & Marketing:Covid_Neg_Sentiment            5.982261e-01 2.463936e+00  0.242792814
c(Industry)Other Industrial Metals & Mining:Covid_Neg_Sentiment          6.582301e+00 6.771892e+00  0.972003246
c(Industry)Other Precious Metals & Mining:Covid_Neg_Sentiment           -5.300888e+00 1.243381e+01 -0.426328695
c(Industry)Packaged Foods:Covid_Neg_Sentiment                           -2.235111e+00 1.369183e+00 -1.632441924
c(Industry)Packaging & Containers:Covid_Neg_Sentiment                   -1.333246e+00 2.843665e+00 -0.468847630
c(Industry)Paper & Paper Products:Covid_Neg_Sentiment                   -3.749152e-01 1.977081e+01 -0.018963067
c(Industry)Personal Services:Covid_Neg_Sentiment                         2.340041e+00 2.545446e+00  0.919304970
c(Industry)Pharmaceutical Retailers:Covid_Neg_Sentiment                  2.241617e+00 3.390877e+00  0.661073059
c(Industry)Pollution & Treatment Controls:Covid_Neg_Sentiment           -5.731503e-01 3.791794e+00 -0.151155432
c(Industry)Publishing:Covid_Neg_Sentiment                               -8.451337e-01 1.742560e+00 -0.484995406
c(Industry)Railroads:Covid_Neg_Sentiment                                -2.422800e+00 3.950388e+00 -0.613306864
c(Industry)Real Estate - Development:Covid_Neg_Sentiment                 1.701270e+00 6.850190e+00  0.248353750
c(Industry)Real Estate - Diversified:Covid_Neg_Sentiment                 2.046798e+00 1.082267e+01  0.189121368
c(Industry)Real Estate Services:Covid_Neg_Sentiment                      2.679592e-01 2.473118e+00  0.108348747
c(Industry)Recreational Vehicles:Covid_Neg_Sentiment                     4.266602e+00 2.974182e+00  1.434546439
c(Industry)REIT - Diversified:Covid_Neg_Sentiment                       -1.955676e-01 4.082608e+00 -0.047902606
c(Industry)REIT - Healthcare Facilities:Covid_Neg_Sentiment              2.013233e+00 2.784973e+00  0.722891382
c(Industry)REIT - Hotel & Motel:Covid_Neg_Sentiment                     -5.415537e+00 3.340751e+00 -1.621053746
c(Industry)REIT - Industrial:Covid_Neg_Sentiment                         2.433877e+00 4.322019e+00  0.563134327
c(Industry)REIT - Mortgage:Covid_Neg_Sentiment                          -2.487849e-02 1.388002e+00 -0.017923960
c(Industry)REIT - Office:Covid_Neg_Sentiment                            -2.255378e+00 2.872369e+00 -0.785197710
c(Industry)REIT - Residential:Covid_Neg_Sentiment                        1.973756e+00 3.907431e+00  0.505128706
c(Industry)REIT - Retail:Covid_Neg_Sentiment                             4.089989e-01 2.534659e+00  0.161362518
c(Industry)REIT - Specialty:Covid_Neg_Sentiment                         -2.574563e-02 2.709516e+00 -0.009501927
c(Industry)Rental & Leasing Services:Covid_Neg_Sentiment                -1.317367e+00 2.310248e+00 -0.570227606
c(Industry)Residential Construction:Covid_Neg_Sentiment                  1.338313e+00 1.445022e+00  0.926154308
c(Industry)Resorts & Casinos:Covid_Neg_Sentiment                         1.030281e+00 2.844202e+00  0.362239148
c(Industry)Restaurants:Covid_Neg_Sentiment                              -1.112118e+00 1.851557e+00 -0.600639568
c(Industry)Scientific & Technical Instruments:Covid_Neg_Sentiment        2.604214e-01 1.875999e+00  0.138817432
c(Industry)Security & Protection Services:Covid_Neg_Sentiment            2.519818e+00 2.191147e+00  1.149999805
c(Industry)Semiconductor Equipment & Materials:Covid_Neg_Sentiment       1.860780e+00 2.263721e+00  0.822000658
c(Industry)Semiconductors:Covid_Neg_Sentiment                           -4.109385e+00 1.755099e+00 -2.341398349
c(Industry)Software - Application:Covid_Neg_Sentiment                    7.575280e-01 9.358366e-01  0.809466094
c(Industry)Software - Infrastructure:Covid_Neg_Sentiment                -1.238162e+00 1.389300e+00 -0.891213211
c(Industry)Solar:Covid_Neg_Sentiment                                     1.703902e+01 9.732546e+00  1.750726454
c(Industry)Specialty Business Services:Covid_Neg_Sentiment              -1.894637e+00 1.831297e+00 -1.034587592
c(Industry)Specialty Chemicals:Covid_Neg_Sentiment                      -3.796260e-01 1.250613e+00 -0.303551923
c(Industry)Specialty Industrial Machinery:Covid_Neg_Sentiment            7.078350e-01 1.132810e+00  0.624848623
c(Industry)Specialty Retail:Covid_Neg_Sentiment                         -9.094907e-01 1.510723e+00 -0.602023248
c(Industry)Staffing & Employment Services:Covid_Neg_Sentiment           -1.135484e+00 1.738222e+00 -0.653244286
c(Industry)Steel:Covid_Neg_Sentiment                                    -8.281974e-01 3.114729e+00 -0.265897077
c(Industry)Telecom Services:Covid_Neg_Sentiment                         -1.726158e+00 2.150719e+00 -0.802595548
c(Industry)Textile Manufacturing:Covid_Neg_Sentiment                    -3.110791e+00 1.990937e+00 -1.562476312
c(Industry)Thermal Coal:Covid_Neg_Sentiment                             -6.388949e-01 2.150006e+00 -0.297159638
c(Industry)Tobacco:Covid_Neg_Sentiment                                   1.321248e+00 2.103394e+00  0.628150499
c(Industry)Tools & Accessories:Covid_Neg_Sentiment                       1.351474e+00 2.251084e+00  0.600365910
c(Industry)Travel Services:Covid_Neg_Sentiment                          -2.155414e+00 4.328675e+00 -0.497938568
c(Industry)Trucking:Covid_Neg_Sentiment                                 -9.170574e+00 7.019977e+00 -1.306353955
c(Industry)Uranium:Covid_Neg_Sentiment                                   4.618726e+00 8.886136e+00  0.519767614
c(Industry)Utilities - Diversified:Covid_Neg_Sentiment                  -1.457708e+00 1.659822e+00 -0.878231627
c(Industry)Utilities - Independent Power Producers:Covid_Neg_Sentiment  -4.076557e+00 5.325085e+00 -0.765538280
c(Industry)Utilities - Regulated Electric:Covid_Neg_Sentiment            4.618102e-01 1.669216e+00  0.276662951
c(Industry)Utilities - Regulated Gas:Covid_Neg_Sentiment                -9.069683e-01 2.651529e+00 -0.342054768
c(Industry)Utilities - Regulated Water:Covid_Neg_Sentiment              -8.760456e-01 3.074388e+00 -0.284949621
c(Industry)Utilities - Renewable:Covid_Neg_Sentiment                    -1.938818e+00 3.763287e+00 -0.515192622
c(Industry)Waste Management:Covid_Neg_Sentiment                          3.915813e-01 3.367934e+00  0.116267495

PercentChange_PosCOVIDSentiment_SharePrices_HierchicalIndustryCompany <- glmer(
  "Percent_Change_bt_DayBefore_y_DayAfter ~ -1 + Day_of_EarningsCall + c(Industry) + Covid_Pos_Sentiment:c(Industry) + (1 | company_name)", 
  data=Closing_Share_Price_Across_Time,
  family=gaussian) 
Warning: calling glmer() with family=gaussian (identity link) as a shortcut to lmer() is deprecated; please call lmer() directlyWarning: Some predictor variables are on very different scales: consider rescaling
summary(PercentChange_PosCOVIDSentiment_SharePrices_HierchicalIndustryCompany)$coefficients  
                                                                             Estimate   Std. Error      t value
Day_of_EarningsCall                                                     -6.480763e-04 3.494135e-04 -1.854754750
c(Industry)Advertising Agencies                                          1.042837e+01 6.684022e+00  1.560193183
c(Industry)Aerospace & Defense                                           1.092200e+01 6.606668e+00  1.653177806
c(Industry)Agricultural Inputs                                           1.313563e+01 6.858568e+00  1.915214697
c(Industry)Airlines                                                      1.146142e+01 6.731902e+00  1.702552786
c(Industry)Airports & Air Services                                       4.956363e+00 1.053082e+01  0.470653250
c(Industry)Aluminum                                                      9.087208e+00 7.583933e+00  1.198218368
c(Industry)Apparel Manufacturing                                         1.381028e+01 6.667850e+00  2.071174092
c(Industry)Apparel Retail                                                1.385801e+01 6.627493e+00  2.090988551
c(Industry)Asset Management                                              1.279489e+01 6.547277e+00  1.954230103
c(Industry)Auto & Truck Dealerships                                      1.527009e+01 6.701012e+00  2.278773805
c(Industry)Auto Manufacturers                                            1.042803e+01 6.999037e+00  1.489922971
c(Industry)Auto Parts                                                    1.371053e+01 6.597338e+00  2.078191586
c(Industry)Banks - Diversified                                           1.050470e+01 7.006221e+00  1.499339520
c(Industry)Banks - Regional                                              1.340495e+01 6.531709e+00  2.052288131
c(Industry)Beverages - Brewers                                           1.087269e+01 7.409684e+00  1.467361764
c(Industry)Beverages - Non-Alcoholic                                     1.038447e+01 6.851898e+00  1.515561303
c(Industry)Beverages - Wineries & Distilleries                           1.194103e+01 9.960011e+00  1.198896867
c(Industry)Biotechnology                                                 1.218259e+01 6.526247e+00  1.866706872
c(Industry)Broadcasting                                                  1.512057e+01 6.760320e+00  2.236664724
c(Industry)Building Materials                                            1.387408e+01 6.993773e+00  1.983776720
c(Industry)Building Products & Equipment                                 1.195061e+01 6.637038e+00  1.800594380
c(Industry)Business Equipment & Supplies                                 3.305891e+00 8.202326e+00  0.403043079
c(Industry)Capital Markets                                               1.227311e+01 6.728495e+00  1.824049511
c(Industry)Chemicals                                                     1.278820e+01 6.873888e+00  1.860402455
c(Industry)Coking Coal                                                   1.460594e+01 7.306438e+00  1.999051125
c(Industry)Communication Equipment                                       1.095124e+01 6.617845e+00  1.654804968
c(Industry)Computer Hardware                                             1.342417e+01 6.699288e+00  2.003820200
c(Industry)Confectioners                                                 1.057309e+01 8.546352e+00  1.237146513
c(Industry)Conglomerates                                                 1.155025e+01 6.702013e+00  1.723400295
c(Industry)Consulting Services                                           1.495768e+01 6.869513e+00  2.177400527
c(Industry)Consumer Electronics                                          6.094175e+00 6.986258e+00  0.872308949
c(Industry)Copper                                                        1.128269e+01 8.142774e+00  1.385607205
c(Industry)Credit Services                                               1.556837e+01 6.649978e+00  2.341116288
c(Industry)Department Stores                                             1.583395e+01 7.282554e+00  2.174230591
c(Industry)Diagnostics & Research                                        1.175726e+01 6.618952e+00  1.776302780
c(Industry)Discount Stores                                               1.104886e+01 6.878484e+00  1.606292255
c(Industry)Drug Manufacturers - General                                  1.210109e+01 6.938221e+00  1.744119873
c(Industry)Drug Manufacturers - Specialty & Generic                      1.141583e+01 6.612153e+00  1.726492408
c(Industry)Education & Training Services                                 1.329819e+01 6.807809e+00  1.953373532
c(Industry)Electrical Equipment & Parts                                  9.285180e+00 6.677842e+00  1.390446266
c(Industry)Electronic Components                                         1.351028e+01 6.614411e+00  2.042551770
c(Industry)Electronic Gaming & Multimedia                                1.756334e+01 8.798218e+00  1.996238718
c(Industry)Electronics & Computer Distribution                           1.200159e+01 6.976736e+00  1.720230258
c(Industry)Engineering & Construction                                    1.314597e+01 6.641424e+00  1.979390858
c(Industry)Entertainment                                                 1.243478e+01 6.686064e+00  1.859805135
c(Industry)Farm & Heavy Construction Machinery                           1.282882e+01 6.660728e+00  1.926039202
c(Industry)Farm Products                                                 7.788786e+00 6.903167e+00  1.128291683
c(Industry)Financial Conglomerates                                       1.230399e+01 7.414054e+00  1.659549521
c(Industry)Financial Data & Stock Exchanges                              1.064935e+01 6.797387e+00  1.566682795
c(Industry)Food Distribution                                             1.091154e+01 6.920305e+00  1.576743446
c(Industry)Footwear & Accessories                                        1.058783e+01 6.692859e+00  1.581959529
c(Industry)Furnishings, Fixtures & Appliances                            1.079110e+01 6.714789e+00  1.607064254
c(Industry)Gambling                                                      1.410033e+01 6.863544e+00  2.054380783
c(Industry)Gold                                                          1.209118e+01 7.185711e+00  1.682669460
c(Industry)Grocery Stores                                                1.424554e+01 7.139452e+00  1.995326099
c(Industry)Health Information Services                                   1.152095e+01 6.681887e+00  1.724205394
c(Industry)Healthcare Plans                                              1.048204e+01 7.024911e+00  1.492124708
c(Industry)Home Improvement Retail                                       1.383190e+01 7.054824e+00  1.960630513
c(Industry)Household & Personal Products                                 1.317325e+01 6.670946e+00  1.974719488
c(Industry)Industrial Distribution                                       1.422289e+01 6.695853e+00  2.124134039
c(Industry)Information Technology Services                               1.262524e+01 6.630118e+00  1.904226263
c(Industry)Infrastructure Operations                                     1.383097e+01 1.345128e+01  1.028226464
c(Industry)Insurance - Diversified                                       1.461535e+01 7.303931e+00  2.001025954
c(Industry)Insurance - Life                                              1.202534e+01 6.742531e+00  1.783506085
c(Industry)Insurance - Property & Casualty                               1.154583e+01 6.617338e+00  1.744784554
c(Industry)Insurance - Reinsurance                                       1.007121e+01 1.162834e+01  0.866091742
c(Industry)Insurance - Specialty                                         1.028037e+01 6.782535e+00  1.515712401
c(Industry)Insurance Brokers                                             6.420508e+00 6.844058e+00  0.938114226
c(Industry)Integrated Freight & Logistics                                1.167471e+01 6.792127e+00  1.718858838
c(Industry)Internet Content & Information                                1.253916e+01 6.731055e+00  1.862881892
c(Industry)Internet Retail                                               1.235228e+01 6.760081e+00  1.827238400
c(Industry)Leisure                                                       1.249032e+01 6.725980e+00  1.857026489
c(Industry)Lodging                                                       1.512383e+01 6.821678e+00  2.217024627
c(Industry)Lumber & Wood Production                                      1.567266e+01 7.251655e+00  2.161253380
c(Industry)Luxury Goods                                                  1.330509e+01 7.476683e+00  1.779544531
c(Industry)Marine Shipping                                               1.322015e+01 7.190493e+00  1.838559295
c(Industry)Medical Care Facilities                                       1.101664e+01 6.654910e+00  1.655415756
c(Industry)Medical Devices                                               1.098659e+01 6.573027e+00  1.671466422
c(Industry)Medical Distribution                                          1.127293e+01 6.869785e+00  1.640944236
c(Industry)Medical Instruments & Supplies                                1.208095e+01 6.612774e+00  1.826910899
c(Industry)Metal Fabrication                                             1.061776e+01 6.729595e+00  1.577770668
c(Industry)Mortgage Finance                                              1.251000e+01 6.850628e+00  1.826110513
c(Industry)Oil & Gas Drilling                                            1.568613e+01 8.465011e+00  1.853054933
c(Industry)Oil & Gas E&P                                                 1.403917e+01 6.628938e+00  2.117861104
c(Industry)Oil & Gas Equipment & Services                                1.158915e+01 6.600341e+00  1.755841200
c(Industry)Oil & Gas Integrated                                          1.077936e+01 7.718485e+00  1.396563723
c(Industry)Oil & Gas Midstream                                           1.258805e+01 6.657182e+00  1.890896960
c(Industry)Oil & Gas Refining & Marketing                                1.239904e+01 6.716188e+00  1.846142934
c(Industry)Other Industrial Metals & Mining                              9.029657e+00 7.656081e+00  1.179409859
c(Industry)Other Precious Metals & Mining                                2.075261e+01 8.888298e+00  2.334823903
c(Industry)Packaged Foods                                                1.114310e+01 6.626291e+00  1.681649159
c(Industry)Packaging & Containers                                        1.332314e+01 6.677622e+00  1.995192495
c(Industry)Paper & Paper Products                                        7.216202e+00 8.680812e+00  0.831281987
c(Industry)Personal Services                                             9.909597e+00 6.882262e+00  1.439874945
c(Industry)Pharmaceutical Retailers                                      7.461004e+00 8.332989e+00  0.895357501
c(Industry)Pollution & Treatment Controls                                1.428268e+01 7.085602e+00  2.015732086
c(Industry)Publishing                                                    1.312842e+01 6.949835e+00  1.889026250
c(Industry)Railroads                                                     1.350003e+01 6.811290e+00  1.982008199
c(Industry)Real Estate - Development                                     1.312612e+01 7.581693e+00  1.731291703
c(Industry)Real Estate - Diversified                                     1.035604e+01 8.546384e+00  1.211744931
c(Industry)Real Estate Services                                          1.383333e+01 6.738473e+00  2.052888283
c(Industry)Recreational Vehicles                                         9.358220e+00 6.919636e+00  1.352415152
c(Industry)REIT - Diversified                                            1.054793e+01 6.778275e+00  1.556137625
c(Industry)REIT - Healthcare Facilities                                  1.098082e+01 6.810217e+00  1.612404588
c(Industry)REIT - Hotel & Motel                                          1.056440e+01 6.665644e+00  1.584903423
c(Industry)REIT - Industrial                                             1.173934e+01 6.734318e+00  1.743210702
c(Industry)REIT - Mortgage                                               1.175510e+01 6.609360e+00  1.778553058
c(Industry)REIT - Office                                                 1.131438e+01 6.705648e+00  1.687291720
c(Industry)REIT - Residential                                            1.205583e+01 6.723755e+00  1.793020995
c(Industry)REIT - Retail                                                 1.376027e+01 6.689176e+00  2.057095454
c(Industry)REIT - Specialty                                              1.193416e+01 6.670228e+00  1.789168448
c(Industry)Rental & Leasing Services                                     1.237342e+01 6.719243e+00  1.841489562
c(Industry)Residential Construction                                      1.363540e+01 6.692857e+00  2.037305895
c(Industry)Resorts & Casinos                                             1.224910e+01 6.711349e+00  1.825131700
c(Industry)Restaurants                                                   1.360270e+01 6.624868e+00  2.053279161
c(Industry)Scientific & Technical Instruments                            1.163888e+01 6.659182e+00  1.747794414
c(Industry)Security & Protection Services                                8.442139e+00 6.850643e+00  1.232313410
c(Industry)Semiconductor Equipment & Materials                           1.140501e+01 6.628619e+00  1.720571220
c(Industry)Semiconductors                                                1.455960e+01 6.596778e+00  2.207076918
c(Industry)Software - Application                                        1.143560e+01 6.565464e+00  1.741780609
c(Industry)Software - Infrastructure                                     1.149430e+01 6.575361e+00  1.748087107
c(Industry)Solar                                                         1.169142e+01 7.061762e+00  1.655594959
c(Industry)Specialty Business Services                                   9.680180e+00 6.692279e+00  1.446469853
c(Industry)Specialty Chemicals                                           1.180190e+01 6.608621e+00  1.785833597
c(Industry)Specialty Industrial Machinery                                1.186090e+01 6.574032e+00  1.804204856
c(Industry)Specialty Retail                                              1.247561e+01 6.614975e+00  1.885964247
c(Industry)Staffing & Employment Services                                1.442620e+01 6.714999e+00  2.148354237
c(Industry)Steel                                                         1.394523e+01 6.828545e+00  2.042196970
c(Industry)Telecom Services                                              1.134670e+01 6.678205e+00  1.699063901
c(Industry)Textile Manufacturing                                         1.153636e+01 7.035232e+00  1.639798212
c(Industry)Thermal Coal                                                  1.371080e+01 7.060577e+00  1.941880717
c(Industry)Tobacco                                                       1.681705e+01 6.861870e+00  2.450796294
c(Industry)Tools & Accessories                                           1.071052e+01 6.838660e+00  1.566171822
c(Industry)Travel Services                                               1.239221e+01 6.935390e+00  1.786808293
c(Industry)Trucking                                                      1.411254e+01 6.884528e+00  2.049892870
c(Industry)Uranium                                                       2.856230e+00 8.232071e+00  0.346963662
c(Industry)Utilities - Diversified                                       1.224321e+01 6.951720e+00  1.761176863
c(Industry)Utilities - Independent Power Producers                       1.554324e+01 8.350932e+00  1.861258034
c(Industry)Utilities - Regulated Electric                                1.168518e+01 6.635099e+00  1.761116230
c(Industry)Utilities - Regulated Gas                                     1.289387e+01 6.797989e+00  1.896717899
c(Industry)Utilities - Regulated Water                                   1.224931e+01 7.069853e+00  1.732611979
c(Industry)Utilities - Renewable                                         1.728952e+01 8.423031e+00  2.052648766
c(Industry)Waste Management                                              1.245228e+01 6.798594e+00  1.831596999
c(Industry)Advertising Agencies:Covid_Pos_Sentiment                      2.593916e+00 2.739333e+00  0.946915442
c(Industry)Aerospace & Defense:Covid_Pos_Sentiment                       2.112406e+00 1.913189e+00  1.104128445
c(Industry)Agricultural Inputs:Covid_Pos_Sentiment                      -1.503986e+00 6.125138e+00 -0.245543220
c(Industry)Airlines:Covid_Pos_Sentiment                                  4.841080e-01 6.419105e+00  0.075416756
c(Industry)Airports & Air Services:Covid_Pos_Sentiment                   4.093735e+00 1.089065e+01  0.375894572
c(Industry)Aluminum:Covid_Pos_Sentiment                                  2.134234e+00 9.504221e+00  0.224556411
c(Industry)Apparel Manufacturing:Covid_Pos_Sentiment                    -2.848886e+00 1.607903e+00 -1.771802178
c(Industry)Apparel Retail:Covid_Pos_Sentiment                            1.627221e+00 2.087803e+00  0.779393898
c(Industry)Asset Management:Covid_Pos_Sentiment                          2.465220e+00 1.516700e+00  1.625383684
c(Industry)Auto & Truck Dealerships:Covid_Pos_Sentiment                 -4.383617e+00 3.668766e+00 -1.194847950
c(Industry)Auto Manufacturers:Covid_Pos_Sentiment                        1.206064e+00 7.397480e+00  0.163037139
c(Industry)Auto Parts:Covid_Pos_Sentiment                               -3.116035e-02 1.421291e+00 -0.021923976
c(Industry)Banks - Diversified:Covid_Pos_Sentiment                      -7.223964e+00 1.553160e+01 -0.465113845
c(Industry)Banks - Regional:Covid_Pos_Sentiment                         -4.502196e-01 1.718026e+00 -0.262056348
c(Industry)Beverages - Brewers:Covid_Pos_Sentiment                       4.875488e+00 7.564512e+00  0.644521151
c(Industry)Beverages - Non-Alcoholic:Covid_Pos_Sentiment                -1.069646e+00 2.456342e+00 -0.435463116
c(Industry)Beverages - Wineries & Distilleries:Covid_Pos_Sentiment      -1.213054e+01 2.299020e+01 -0.527639706
c(Industry)Biotechnology:Covid_Pos_Sentiment                            -1.356546e+00 7.121757e-01 -1.904791522
c(Industry)Broadcasting:Covid_Pos_Sentiment                             -2.398404e+00 4.199956e+00 -0.571054634
c(Industry)Building Materials:Covid_Pos_Sentiment                       -7.451562e+00 9.088900e+00 -0.819853042
c(Industry)Building Products & Equipment:Covid_Pos_Sentiment             3.636152e+00 2.673142e+00  1.360254142
c(Industry)Business Equipment & Supplies:Covid_Pos_Sentiment             1.370228e+01 1.312383e+01  1.044076106
c(Industry)Capital Markets:Covid_Pos_Sentiment                          -1.652314e+00 6.459911e+00 -0.255779745
c(Industry)Chemicals:Covid_Pos_Sentiment                                 1.610821e+00 4.025905e+00  0.400113991
c(Industry)Coking Coal:Covid_Pos_Sentiment                              -8.352731e+00 1.210462e+01 -0.690044659
c(Industry)Communication Equipment:Covid_Pos_Sentiment                   2.111117e+00 2.353134e+00  0.897150977
c(Industry)Computer Hardware:Covid_Pos_Sentiment                         3.822151e-01 2.463012e+00  0.155181995
c(Industry)Confectioners:Covid_Pos_Sentiment                             2.450511e+00 4.992889e+00  0.490800210
c(Industry)Conglomerates:Covid_Pos_Sentiment                             2.283845e+00 2.787144e+00  0.819421332
c(Industry)Consulting Services:Covid_Pos_Sentiment                      -4.161417e+00 3.759286e+00 -1.106969958
c(Industry)Consumer Electronics:Covid_Pos_Sentiment                      1.578857e+01 5.963664e+00  2.647461178
c(Industry)Copper:Covid_Pos_Sentiment                                    2.714857e-01 1.382374e+01  0.019639090
c(Industry)Credit Services:Covid_Pos_Sentiment                           2.684291e+00 3.267328e+00  0.821555483
c(Industry)Department Stores:Covid_Pos_Sentiment                        -2.164731e+01 8.664242e+00 -2.498465566
c(Industry)Diagnostics & Research:Covid_Pos_Sentiment                    3.486978e-01 1.008863e+00  0.345634488
c(Industry)Discount Stores:Covid_Pos_Sentiment                          -3.230360e+00 6.499580e+00 -0.497010564
c(Industry)Drug Manufacturers - General:Covid_Pos_Sentiment             -4.142520e-01 2.058978e+00 -0.201192988
c(Industry)Drug Manufacturers - Specialty & Generic:Covid_Pos_Sentiment -4.342787e-01 9.515738e-01 -0.456379404
c(Industry)Education & Training Services:Covid_Pos_Sentiment             9.604020e-01 3.676635e+00  0.261217634
c(Industry)Electrical Equipment & Parts:Covid_Pos_Sentiment              5.940053e-01 2.389864e+00  0.248551938
c(Industry)Electronic Components:Covid_Pos_Sentiment                    -1.336438e+00 1.741702e+00 -0.767317610
c(Industry)Electronic Gaming & Multimedia:Covid_Pos_Sentiment           -2.551066e-01 2.684263e+01 -0.009503785
c(Industry)Electronics & Computer Distribution:Covid_Pos_Sentiment       6.782632e+00 5.689725e+00  1.192084246
c(Industry)Engineering & Construction:Covid_Pos_Sentiment               -1.218030e+00 2.108655e+00 -0.577633393
c(Industry)Entertainment:Covid_Pos_Sentiment                             8.957934e-01 2.401584e+00  0.373001042
c(Industry)Farm & Heavy Construction Machinery:Covid_Pos_Sentiment      -8.495478e-01 2.559615e+00 -0.331904580
c(Industry)Farm Products:Covid_Pos_Sentiment                             4.296956e+00 3.939204e+00  1.090818524
c(Industry)Financial Conglomerates:Covid_Pos_Sentiment                   3.927945e+00 5.587354e+00  0.703006286
c(Industry)Financial Data & Stock Exchanges:Covid_Pos_Sentiment          5.403822e+00 7.658413e+00  0.705605966
c(Industry)Food Distribution:Covid_Pos_Sentiment                         1.877787e+00 4.348953e+00  0.431779028
c(Industry)Footwear & Accessories:Covid_Pos_Sentiment                    6.281802e+00 2.957190e+00  2.124246975
c(Industry)Furnishings, Fixtures & Appliances:Covid_Pos_Sentiment        2.915760e+00 2.655906e+00  1.097840052
c(Industry)Gambling:Covid_Pos_Sentiment                                  3.417196e+00 4.015217e+00  0.851061389
c(Industry)Gold:Covid_Pos_Sentiment                                      1.053177e+00 5.974968e+00  0.176264819
c(Industry)Grocery Stores:Covid_Pos_Sentiment                           -1.612833e+00 5.537980e+00 -0.291231302
c(Industry)Health Information Services:Covid_Pos_Sentiment              -2.103104e+00 2.320414e+00 -0.906348672
c(Industry)Healthcare Plans:Covid_Pos_Sentiment                          2.604182e+00 3.564516e+00  0.730584919
c(Industry)Home Improvement Retail:Covid_Pos_Sentiment                  -5.639707e+00 6.658115e+00 -0.847042642
c(Industry)Household & Personal Products:Covid_Pos_Sentiment             8.918008e-01 2.248937e+00  0.396543286
c(Industry)Industrial Distribution:Covid_Pos_Sentiment                  -7.378891e-01 2.808451e+00 -0.262738792
c(Industry)Information Technology Services:Covid_Pos_Sentiment           3.564442e+00 1.869993e+00  1.906126299
c(Industry)Infrastructure Operations:Covid_Pos_Sentiment                -1.075726e+00 2.235245e+01 -0.048125644
c(Industry)Insurance - Diversified:Covid_Pos_Sentiment                  -1.319036e+00 5.394564e+00 -0.244511999
c(Industry)Insurance - Life:Covid_Pos_Sentiment                         -9.111031e-01 1.989157e+00 -0.458034738
c(Industry)Insurance - Property & Casualty:Covid_Pos_Sentiment           1.973591e+00 1.795103e+00  1.099430354
c(Industry)Insurance - Reinsurance:Covid_Pos_Sentiment                   3.136442e+00 6.801187e+00  0.461161033
c(Industry)Insurance - Specialty:Covid_Pos_Sentiment                    -3.643746e-01 3.715963e+00 -0.098056570
c(Industry)Insurance Brokers:Covid_Pos_Sentiment                         6.293480e+00 4.080382e+00  1.542375116
c(Industry)Integrated Freight & Logistics:Covid_Pos_Sentiment            2.742560e+00 5.889546e+00  0.465665783
c(Industry)Internet Content & Information:Covid_Pos_Sentiment            8.347005e+00 3.634964e+00  2.296310089
c(Industry)Internet Retail:Covid_Pos_Sentiment                           2.653161e+00 3.021488e+00  0.878097246
c(Industry)Leisure:Covid_Pos_Sentiment                                   2.252968e+00 3.021956e+00  0.745533097
c(Industry)Lodging:Covid_Pos_Sentiment                                  -3.808193e+00 5.682343e+00 -0.670180050
c(Industry)Lumber & Wood Production:Covid_Pos_Sentiment                 -4.973396e+00 4.782301e+00 -1.039958951
c(Industry)Luxury Goods:Covid_Pos_Sentiment                             -5.912460e+00 5.052559e+00 -1.170191081
c(Industry)Marine Shipping:Covid_Pos_Sentiment                          -1.317981e+00 6.695692e+00 -0.196840130
c(Industry)Medical Care Facilities:Covid_Pos_Sentiment                   2.812235e+00 1.276125e+00  2.203731165
c(Industry)Medical Devices:Covid_Pos_Sentiment                           5.598760e-01 7.578949e-01  0.738725142
c(Industry)Medical Distribution:Covid_Pos_Sentiment                      1.600914e-01 2.848701e+00  0.056198049
c(Industry)Medical Instruments & Supplies:Covid_Pos_Sentiment           -1.721686e-02 9.721284e-01 -0.017710484
c(Industry)Metal Fabrication:Covid_Pos_Sentiment                         7.919456e-01 2.480992e+00  0.319205214
c(Industry)Mortgage Finance:Covid_Pos_Sentiment                          1.659657e+00 3.739599e+00  0.443806208
c(Industry)Oil & Gas Drilling:Covid_Pos_Sentiment                       -8.120307e+00 1.314601e+01 -0.617701310
c(Industry)Oil & Gas E&P:Covid_Pos_Sentiment                            -5.858941e+00 4.348606e+00 -1.347314743
c(Industry)Oil & Gas Equipment & Services:Covid_Pos_Sentiment           -4.605229e-01 3.134537e+00 -0.146918973
c(Industry)Oil & Gas Integrated:Covid_Pos_Sentiment                      7.500157e+00 2.355125e+01  0.318461136
c(Industry)Oil & Gas Midstream:Covid_Pos_Sentiment                      -8.784905e-01 4.943681e+00 -0.177699671
c(Industry)Oil & Gas Refining & Marketing:Covid_Pos_Sentiment            3.296707e+00 3.166265e+00  1.041197281
c(Industry)Other Industrial Metals & Mining:Covid_Pos_Sentiment          9.532702e+00 1.057847e+01  0.901141569
c(Industry)Other Precious Metals & Mining:Covid_Pos_Sentiment           -2.888054e+01 2.775792e+01 -1.040443275
c(Industry)Packaged Foods:Covid_Pos_Sentiment                            1.101312e+00 1.837199e+00  0.599451723
c(Industry)Packaging & Containers:Covid_Pos_Sentiment                   -1.878298e+00 3.079296e+00 -0.609976590
c(Industry)Paper & Paper Products:Covid_Pos_Sentiment                   -2.431713e+01 2.516770e+01 -0.966204157
c(Industry)Personal Services:Covid_Pos_Sentiment                         7.463981e+00 4.097434e+00  1.821623257
c(Industry)Pharmaceutical Retailers:Covid_Pos_Sentiment                  5.457397e+00 7.659418e+00  0.712508019
c(Industry)Pollution & Treatment Controls:Covid_Pos_Sentiment           -4.492375e+00 5.992303e+00 -0.749690931
c(Industry)Publishing:Covid_Pos_Sentiment                               -1.250694e+00 3.286878e+00 -0.380511247
c(Industry)Railroads:Covid_Pos_Sentiment                                -3.320264e+00 5.922515e+00 -0.560617183
c(Industry)Real Estate - Development:Covid_Pos_Sentiment                 1.158513e+01 1.265331e+01  0.915580882
c(Industry)Real Estate - Diversified:Covid_Pos_Sentiment                 5.452659e+00 8.097080e+00  0.673410495
c(Industry)Real Estate Services:Covid_Pos_Sentiment                      2.117549e+00 4.870657e+00  0.434756213
c(Industry)Recreational Vehicles:Covid_Pos_Sentiment                     1.147130e+01 5.874093e+00  1.952863587
c(Industry)REIT - Diversified:Covid_Pos_Sentiment                        2.888339e+00 4.287093e+00  0.673729054
c(Industry)REIT - Healthcare Facilities:Covid_Pos_Sentiment              3.336905e+00 2.467523e+00  1.352329745
c(Industry)REIT - Hotel & Motel:Covid_Pos_Sentiment                      5.418223e+00 4.320504e+00  1.254071843
c(Industry)REIT - Industrial:Covid_Pos_Sentiment                         1.543649e+00 4.018723e+00  0.384114339
c(Industry)REIT - Mortgage:Covid_Pos_Sentiment                           1.395108e+00 2.464150e+00  0.566161908
c(Industry)REIT - Office:Covid_Pos_Sentiment                             1.536774e+00 3.225016e+00  0.476516918
c(Industry)REIT - Residential:Covid_Pos_Sentiment                        4.295472e+00 4.303557e+00  0.998121380
c(Industry)REIT - Retail:Covid_Pos_Sentiment                            -1.515444e+00 3.102265e+00 -0.488495884
c(Industry)REIT - Specialty:Covid_Pos_Sentiment                          1.405069e+00 2.648774e+00  0.530460267
c(Industry)Rental & Leasing Services:Covid_Pos_Sentiment                -1.853363e+00 3.488174e+00 -0.531327642
c(Industry)Residential Construction:Covid_Pos_Sentiment                  4.328374e+00 3.446558e+00  1.255854052
c(Industry)Resorts & Casinos:Covid_Pos_Sentiment                         3.861272e+00 3.790169e+00  1.018759902
c(Industry)Restaurants:Covid_Pos_Sentiment                               1.462610e+00 2.085535e+00  0.701311742
c(Industry)Scientific & Technical Instruments:Covid_Pos_Sentiment        1.634261e-01 2.836726e+00  0.057610835
c(Industry)Security & Protection Services:Covid_Pos_Sentiment            3.446536e+00 3.435726e+00  1.003146238
c(Industry)Semiconductor Equipment & Materials:Covid_Pos_Sentiment       4.536723e+00 2.814747e+00  1.611769289
c(Industry)Semiconductors:Covid_Pos_Sentiment                           -1.921705e-01 1.975437e+00 -0.097280011
c(Industry)Software - Application:Covid_Pos_Sentiment                    3.154809e-01 1.089021e+00  0.289692195
c(Industry)Software - Infrastructure:Covid_Pos_Sentiment                 1.922464e+00 1.373224e+00  1.399963284
c(Industry)Solar:Covid_Pos_Sentiment                                     1.845087e+01 8.482736e+00  2.175107925
c(Industry)Specialty Business Services:Covid_Pos_Sentiment               2.565689e+00 3.176503e+00  0.807708713
c(Industry)Specialty Chemicals:Covid_Pos_Sentiment                      -6.022317e-01 1.737021e+00 -0.346703759
c(Industry)Specialty Industrial Machinery:Covid_Pos_Sentiment            2.497347e+00 1.486578e+00  1.679930503
c(Industry)Specialty Retail:Covid_Pos_Sentiment                          3.734398e+00 2.499946e+00  1.493791414
c(Industry)Staffing & Employment Services:Covid_Pos_Sentiment           -7.802442e-01 3.060720e+00 -0.254921784
c(Industry)Steel:Covid_Pos_Sentiment                                    -6.088414e-01 4.400949e+00 -0.138343185
c(Industry)Telecom Services:Covid_Pos_Sentiment                          2.644405e+00 3.645813e+00  0.725326416
c(Industry)Textile Manufacturing:Covid_Pos_Sentiment                    -5.539360e+00 2.659748e+00 -2.082663289
c(Industry)Thermal Coal:Covid_Pos_Sentiment                             -3.153924e+00 4.570992e+00 -0.689986826
c(Industry)Tobacco:Covid_Pos_Sentiment                                  -4.810581e+00 3.412838e+00 -1.409554176
c(Industry)Tools & Accessories:Covid_Pos_Sentiment                       3.205539e+00 4.858048e+00  0.659840869
c(Industry)Travel Services:Covid_Pos_Sentiment                           4.796398e-01 5.811530e+00  0.082532448
c(Industry)Trucking:Covid_Pos_Sentiment                                 -6.002251e+00 7.282283e+00 -0.824226451
c(Industry)Uranium:Covid_Pos_Sentiment                                   4.711619e+00 7.739967e+00  0.608738813
c(Industry)Utilities - Diversified:Covid_Pos_Sentiment                  -1.676615e+00 3.187746e+00 -0.525956360
c(Industry)Utilities - Independent Power Producers:Covid_Pos_Sentiment  -7.731825e+00 1.008923e+01 -0.766344326
c(Industry)Utilities - Regulated Electric:Covid_Pos_Sentiment            2.167544e+00 2.244653e+00  0.965647413
c(Industry)Utilities - Regulated Gas:Covid_Pos_Sentiment                 7.067146e-01 3.390434e+00  0.208443727
c(Industry)Utilities - Regulated Water:Covid_Pos_Sentiment               2.110726e+00 5.537539e+00  0.381166777
c(Industry)Utilities - Renewable:Covid_Pos_Sentiment                    -1.207562e+01 1.052067e+01 -1.147799013
c(Industry)Waste Management:Covid_Pos_Sentiment                         -6.418740e-01 2.493675e+00 -0.257400831

saveRDS(PercentChange_SharePrices_HierchicalIndustryCompany, file="../data/MixedEffects_HierarchicalModel.RDS")
summary(PercentChange_SharePrices_HierchicalIndustryCompany)$coefficientsp[,4]  
NULL
tidy(PercentChange_SharePrices_HierchicalIndustryCompany, conf.int=TRUE)
FixedEffects_IndustryCoefficients <- tidy(PercentChange_SharePrices_HierchicalIndustryCompany, conf.int=TRUE) |> 
  filter(effect=="fixed")  

FixedEffects_IndustryCoefficients
StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment <- FixedEffects_IndustryCoefficients |> 
  filter(conf.high < 0 | conf.low > 0)  

StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment
tidy(PercentChange_SharePrices_HierchicalIndustryCompany, conf.int=TRUE) |> 
  filter(effect=="fixed") |> 
  ggplot(aes(x=reorder(term, estimate), y=estimate)) +
  geom_point() +
  geom_errorbar(aes(ymin=conf.low, ymax=conf.high, width=0.05)) +
  labs(x="Industries") + 
  labs(y="% Change in Share Price as A Function of Net COVID Sentiment") +
  coord_flip() 

Closing_Share_Price_Across_Time_DropNA <- Closing_Share_Price_Across_Time |> drop_na(`Percent_Change_bt_DayBefore_y_DayAfter`, `Industry`, `Day_of_EarningsCall`, `company_name`, `Covid_Net_Sentiment`)

Closing_Share_Price_Across_Time_DropNA
tibble(resid=resid(PercentChange_SharePrices_HierchicalIndustryCompany), date=Closing_Share_Price_Across_Time_DropNA$Day_of_EarningsCall) |> 
  filter(date > "2019-01-01") |> 
  ggplot(aes(x=date, y=resid)) +
  geom_point(alpha=0.2) +
  geom_smooth() +
  ylim(-25, 25)

# stat_poly_eq(use_label(c("eq", "adj.R2", "f", "p", "n")), vstep=22, size=3.8) 
cIndustry_Removal = function(lab) {
  str_remove(lab, "c\\(Industry\\)")  
}

DayOfEarningsCall_Removal = function(lab) {
  str_remove(lab, "Day_of_EarningsCall")  
}
StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment <- StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment |> mutate(term = cIndustry_Removal(term)) |> mutate(term = DayOfEarningsCall_Removal(term))

StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment

BarGraph_StatSig_Industries <- ggplot(data=StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment, aes(x=reorder(term, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Industries") + 
  labs(y="% Change in Stock Price as A Function of Net COVID Sentiment") + 
  labs(title="Notable Industries Whose Share Prices Outperformed", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

BarGraph_StatSig_Industries

StatSig_IndustryNetCOVIDSentimentInteraction <- StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment |> filter(str_detect(term, ":Covid_Net_Sentiment"))
StatSig_IndustryNetCOVIDSentimentInteraction
StatSig_Industries <- StatSig_Industries_Time_y_InteractionTermIndustryNetCOVIDSentiment |> filter(!str_detect(term, ":Covid_Net_Sentiment"))
StatSig_Industries

InteractionTermLabel_Removal = function(lab) {
  str_remove(lab, ":Covid_Net_Sentiment")  
}

StatSig_IndustryNetCOVIDSentimentInteraction_TrimmedLabels <- StatSig_IndustryNetCOVIDSentimentInteraction |> mutate(term = InteractionTermLabel_Removal(term))

BarGraph_StatSig_IndustryNetCOVIDSentimentInteraction_TrimmedLabels <- ggplot(data=StatSig_IndustryNetCOVIDSentimentInteraction_TrimmedLabels, aes(x=reorder(term, estimate), y=estimate)) +
                                                          geom_bar(stat="identity", fill="steelblue") +
                                                          coord_flip() +
                                                          theme_minimal() +
                                                          labs(x="Industries") + 
                                                          labs(y="% Change in Stock Price as A Function of Net COVID Sentiment") + 
                                                          labs(title="Industries Whose Stock Price Changes Disproportionally Correlate with Net COVID Sentiment", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

BarGraph_StatSig_IndustryNetCOVIDSentimentInteraction_TrimmedLabels

NA
NA

BarGraph_StatSig_Industries <- ggplot(data=StatSig_Industries, aes(x=reorder(term, estimate), y=estimate)) +
                                                          geom_bar(stat="identity", fill="steelblue") +
                                                          coord_flip() +
                                                          theme_minimal() +
                                                          labs(x="Industries") + 
                                                          labs(y="% Change in Stock Price as A Function of Net COVID Sentiment") + 
                                                          labs(title="Industries Whose Stock Price Changes Statistically Significantly Correlate with Net COVID Sentiment", subtitle="Mixed-Effect Linear Regression Analysis of How Changes in Stock Price Correlate with Net COVID-Related Sentiment")

BarGraph_StatSig_Industries

NA
NA
tidy(PercentChange_SharePrices_HierchicalIndustryCompany, effects="ran_vals", conf.int=TRUE) 
Random_Effect_Coeff_Desc <- tidy(PercentChange_SharePrices_HierchicalIndustryCompany, effects="ran_vals", conf.int=TRUE) |> arrange(desc(estimate))
Random_Effect_Coeff_Desc 
Company_Industry  <- Closing_Share_Price_Across_Time |> 
  select(company_name, Industry) |> 
  unique()

Company_Industry 
Firm_Industry_Random_Effect_Coeff_Desc <- Random_Effect_Coeff_Desc  |> 
  inner_join(Company_Industry, by=join_by(level==company_name))

Firm_Industry_Random_Effect_Coeff_Desc

Let’s look at stock performance of firms within industries whose share price changes were less impacted by Net COVID Sentiment.

Grocery_Stores <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Grocery Stores"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Grocery Stores with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Grocery_Stores

Auto_n_Truck_Dealerships <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Auto & Truck Dealerships"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Auto/Truck Dealership Firms with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Auto_n_Truck_Dealerships

Industrial_Distribution <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Industrial Distribution"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Industrial Distribution Firms with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Industrial_Distribution

Then, let’s look at stock performance of firms within industries whose share price changes were more impacted by Net COVID Sentiment.

Discount_Stores <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Discount Stores"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Discount Stores with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Discount_Stores

Consumer_Electronics <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Consumer Electronics"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Consumer Electronics Firms with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Consumer_Electronics 

Integrated_Freight_n_Logistics <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Integrated Freight & Logistics"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Integrated Freight & Logistics Firms with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Integrated_Freight_n_Logistics

Next, let’s look into notable industries whose share prices outperformed those in other industries:

Electronic_Gaming_n_Multimedia <- ggplot(data=Firm_Industry_Random_Effect_Coeff_Desc |> filter(Industry=="Electronic Gaming & Multimedia"), aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industry Average") + 
  labs(title="Changes in Stock Prices of Electronic Gaming & Multimedia Firms with Respect to Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

Electronic_Gaming_n_Multimedia

TopFirms <- Random_Effect_Coeff_Desc |> 
  filter(conf.low > 0)
TopFirms
BottomFirms <- Random_Effect_Coeff_Desc |> 
  filter(conf.high < 0)
BottomFirms 
StatSig_Firms <- Random_Effect_Coeff_Desc |> 
  filter(conf.high < 0 | conf.low > 0)
StatSig_Firms 
Top20Firms <- Random_Effect_Coeff_Desc |> head(20) 
Top20Firms

Add a boolean statistical significance column:


Firm_Industry_Random_Effect_Coeff_Desc_StatSig <- Random_Effect_Coeff_Desc  |> 
  inner_join(Company_Industry, by=join_by(level==company_name)) |> 
  select(level, estimate, conf.low, conf.high, Industry) |> 
  filter(conf.high < 0 | conf.low > 0) |> 
  mutate(`Statistically Significant?`="Yes")

Firm_Industry_Random_Effect_Coeff_Desc_StatSig

Firm_Industry_Random_Effect_Coeff_Desc_StatInsig <- Random_Effect_Coeff_Desc  |> 
  inner_join(Company_Industry, by=join_by(level==company_name)) |> 
  select(level, estimate, conf.low, conf.high, Industry) |> 
  filter(conf.high > 0 & conf.low < 0) |> 
  mutate(`Statistically Significant?`="No")

Firm_Industry_Random_Effect_Coeff_Desc_StatInsig

Piecing the firms whose stats are statistically significant back together with those whose stats aren’t:

Firm_Industry_Random_Effect_Coeff_Desc_StatSig_y_StatInsig <- bind_rows(Firm_Industry_Random_Effect_Coeff_Desc_StatSig, Firm_Industry_Random_Effect_Coeff_Desc_StatInsig)

Firm_Industry_Random_Effect_Coeff_Desc_StatSig_y_StatInsig
BarGraph_AllFirms <- ggplot(data=Random_Effect_Coeff_Desc, aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="% of Additional Correlative Change in Stock Price from Industry Average") + 
  labs(title="Stellar Companies Whose Share Prices Outperformed Those in Their Respective Industries", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

BarGraph_AllFirms 

BarGraph_StatSig_Firms <- ggplot(data=StatSig_Firms, aes(x=reorder(level, estimate), y=estimate)) +
  geom_bar(stat="identity", fill="steelblue") +
  coord_flip() +
  theme_minimal() +
  labs(x="Companies") + 
  labs(y="Additional % of Correlative Change in Stock Price from Industrial Average") + 
  labs(title="Notable Companies Whose Correlational Performance Exceeded Their Respective Industry", subtitle="Mixed-Effect Linear Regression Analysis of How Percentage Change in Share Price Correlates with Net COVID-Related Sentiment")

BarGraph_StatSig_Firms

select_company=c("Carmax Inc")

Closing_Share_Price_Across_Time_DropNA_highlight <- Closing_Share_Price_Across_Time_DropNA |> 
  mutate(highlight=case_when(company_name %in% select_company ~ TRUE,
                               .default=FALSE))

Closing_Share_Price_Across_Time_DropNA_highlight |> 
  filter(Industry==(Industry[(Closing_Share_Price_Across_Time_DropNA_highlight$company_name=="Lovesac Co")] |> unique())) |> 
  ggplot(aes(x=Day_of_EarningsCall, y=Percent_Change_bt_DayBefore_y_DayAfter)) +
  geom_point(aes(size=Covid_Net_Sentiment, color=highlight), alpha=0.7, show.legend=FALSE) +
  geom_smooth(method=lm, formula=y ~ x) + 
  scale_color_manual(values=c("orange", "black")) +
  # scale_size_manual(values=c(1, 3)) +
  # geom_label_repel(data=Closing_Share_Price_Across_Time_DropNA_highlight |> filter(highlight==TRUE), aes(label=company_name)) +
  stat_poly_eq(use_label(c("eq", "adj.R2", "f", "p", "n")), vstep=22, size=3.8) 

# vcov(PercentChange_SharePrices_HierchicalIndustryCompany)
LS0tCnRpdGxlOiAiRmluZGluZyBGaXJtcyB3aXRoIExhcmdlc3QgRGVsdGEgaW4gTmV0IENPVklEIFNlbnRpbWVudCIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKCgpgYGB7cn0KbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkoZ2dwbG90MikKbGlicmFyeShkcGx5cikKbGlicmFyeShsdWJyaWRhdGUpCmxpYnJhcnkoY29ycnIpCmxpYnJhcnkoaGF2ZW4pCmxpYnJhcnkobG1lNCkgCmxpYnJhcnkoYnJvb20ubWl4ZWQpIApsaWJyYXJ5KGdncmVwZWwpCmxpYnJhcnkoZ2dwdWJyKQpsaWJyYXJ5KGdncG1pc2MpCmBgYAoKCgoKUmVhZCBpbiBkYXRhIGZpbGUgIAoKYGBge3J9CgpmaXJtcyA8LSByZWFkX2R0YSgnLi4vZGF0YS9maXJtcXVhcnRlcl8yMDIycTEuZHRhJykKZmlybXMgCgpgYGAKCgpGaW5kIGVudHJpZXMgd2hvc2UgQ09WSUQgTmV0IFNlbnRpbWVudCBpc24ndCAwCgpgYGB7cn0KTm9uWmVyb19GaXJtcyA8LSBmaXJtcyB8PiAKICBmaWx0ZXIoYENvdmlkX05ldF9TZW50aW1lbnRgICE9IDApIHw+IAogIGZpbHRlcihocWNvdW50cnljb2RlPT0nVVMnKSB8PiAKICBtdXRhdGUoRGF5X29mX0Vhcm5pbmdzQ2FsbD1kbXkoZGF0ZV9lYXJuaW5nc2NhbGwpKSAKCk5vblplcm9fRmlybXMgCmBgYAoKCkZpbmQgZmlybXMgKGFuZCB0aGVpciBlYXJuaW5ncyBjYWxscykgdGhlIGxhcmdlc3QgRGVsdGFzIGluIHRoZWlyIE5ldCBDT1ZJRCBTZW50aW1lbnRzIG92ZXIgdGltZS4KCmBgYHtyfQoKTWluX01heF9OZXRfQ09WSURfU2VudGltZW50cyA8LSBOb25aZXJvX0Zpcm1zIHw+IAogIGdyb3VwX2J5KGNvbXBhbnlfbmFtZSkgfD4gCiAgbXV0YXRlKE1pbl9OZXRfQ09WSURfU2VudGltZW50PW1pbihDb3ZpZF9OZXRfU2VudGltZW50KSkgfD4gCiAgbXV0YXRlKE1heF9OZXRfQ09WSURfU2VudGltZW50PW1heChDb3ZpZF9OZXRfU2VudGltZW50KSkgfD4gCiAgbXV0YXRlKERlbHRhX05ldF9DT1ZJRF9TZW50aW1lbnQ9TWF4X05ldF9DT1ZJRF9TZW50aW1lbnQgLSBNaW5fTmV0X0NPVklEX1NlbnRpbWVudCkgfD4gCiAgYXJyYW5nZShkZXNjKERlbHRhX05ldF9DT1ZJRF9TZW50aW1lbnQpKQojICBhcnJhbmdlKGRlc2ModGlja2VyKSkgfD4gCiMgICAgYXJyYW5nZShEYXlfb2ZfRWFybmluZ3NDYWxsKSAKCk1pbl9NYXhfTmV0X0NPVklEX1NlbnRpbWVudHMgIAoKYGBgCgoKCgoKRmluZCB0b3AgZmlybXMgd2l0aCB0aGUgbGFyZ2VzdCBEZWx0YXMgaW4gdGhlaXIgTmV0IENPVklEIFNlbnRpbWVudHMgb3ZlciB0aW1lLgoKCmBgYHtyfQoKIyBUb3BfRmlybXMgPC0gTWluX01heF9OZXRfQ09WSURfU2VudGltZW50cyAgfD4gCiMgICAgICAgICAgICAgICAgICAgZGlzdGluY3QoY29tcGFueV9uYW1lKSAgCiMgVG9wX0Zpcm1zCgojIHdyaXRlX2NzdihUb3BfRmlybXMsICcuLi9kYXRhL1RvcF9GaXJtcy5jc3YnKQoKCmBgYApgYGB7cn0KCiMgRGF0ZXNfTWluX01heF9OZXRfQ09WSURfU2VudGltZW50cyA8LSBNaW5fTWF4X05ldF9DT1ZJRF9TZW50aW1lbnRzIHw+IAojICAgICAgICAgICBncm91cF9ieShjb21wYW55X25hbWUpIHw+IAojICAgICAgICAgICBmaWx0ZXIoQ292aWRfTmV0X1NlbnRpbWVudD09TWluX05ldF9DT1ZJRF9TZW50aW1lbnQgfCBDb3ZpZF9OZXRfU2VudGltZW50PT1NYXhfTmV0X0NPVklEX1NlbnRpbWVudCkgfD4gCiMgICAgICAgICAgIGFycmFuZ2UoZGVzYyhEZWx0YV9OZXRfQ09WSURfU2VudGltZW50KSkKIyAKIyBEYXRlc19NaW5fTWF4X05ldF9DT1ZJRF9TZW50aW1lbnRzCgoKIyB3cml0ZV9jc3YoRGF0ZXNfTWluX01heF9OZXRfQ09WSURfU2VudGltZW50cywgJy4uL2RhdGEvRGF0ZXNfTWluX01heF9OZXRfQ09WSURfU2VudGltZW50cy5jc3YnKQoKYGBgCgoKRmluZCB1bmlxdWUgdGlja2VyIHN5bWJvbHM6CgpgYGB7cn0KIyBUaWNrZXJzIDwtIERhdGVzX01pbl9NYXhfTmV0X0NPVklEX1NlbnRpbWVudHMgfD4gCiMgICBncm91cF9ieShjb21wYW55X25hbWUpIHw+IAojICAgZGlzdGluY3QodGlja2VyKQpgYGAKCgpgYGB7cn0KIyBVU19UaWNrZXJzIDwtIHJlYWRfY3N2KCcuLi9kYXRhL0Rlc2NlbmRpbmdVU1RpY2tlcnNfRXh0ZW5kZWQuY3N2JykgCiMgCiMgVVNfVGlja2VycyA8LSBVU19UaWNrZXJzIHw+IAojICAgICAgICAgICAgICAgICAgIGRpc3RpbmN0KHRpY2tlcikKCiMgd3JpdGVfY3N2KFVTX1RpY2tlcnMsICcuLi9kYXRhL1VTX1RpY2tlcnMuY3N2JykKCmBgYAoKCgpJbnNlcnQgaW5kdXN0cnkgaW5mbyB2aWEgam9pbjoKCmBgYHtyfQoKIyBJbmR1c3RyaWVzIDwtIHJlYWRfY3N2KCcuLi9kYXRhL0NvbXBhbnlOYW1lX1RpY2tlcl9JbmR1c3RyeS5jc3YnKQojIEluZHVzdHJpZXMKCmBgYApgYGB7cn0KCiMgSW5kdXN0cmllcyA8LSBJbmR1c3RyaWVzIHw+IAojICAgICAgICAgICAgICAgICBzZWxlY3QoLXRpY2tlcikKIyBJbmR1c3RyaWVzCgpgYGAKCmBgYHtyfQoKIyBOZXRfQ09WSURfU2VudGltZW50c19JbmR1c3RyaWVzIDwtIE1pbl9NYXhfTmV0X0NPVklEX1NlbnRpbWVudHMgfD4gCiMgICAgIGlubmVyX2pvaW4oSW5kdXN0cmllcywgYnk9am9pbl9ieShjb21wYW55X25hbWUpKQojIAojIE5ldF9DT1ZJRF9TZW50aW1lbnRzX0luZHVzdHJpZXMKCmBgYAoKRXhwb3J0aW5nIGRhdGEgZm9yIGZldGNoaW5nIG9mIHNoYXJlIHByaWNlIGRhdGE6CkFycmFuZ2luZyB0aWNrZXJzIGJ5IGRlc2NlbmRpbmcgb3JkZXIgaW4gb3JkZXIgdG8gcGxhY2UgdGhlIGVudHJpZXMgd2l0aG91dCB0aWNrZXJzIGF0IHRoZSBlbmQKCmBgYHtyfQoKIyBTaGFyZVByaWNlX1dyaXRlX0NTVl9QcmVwIDwtIE5ldF9DT1ZJRF9TZW50aW1lbnRzX0luZHVzdHJpZXMgfD4KIyAgIGFycmFuZ2UoZGVzYyh0aWNrZXIpKSB8PiAKIyAgIGFycmFuZ2UoZGVzYyhJbmR1c3RyeSkpCiMgCiMgd3JpdGVfY3N2KFNoYXJlUHJpY2VfV3JpdGVfQ1NWX1ByZXAsICIuLi9kYXRhL0Rlc2NlbmRpbmdfVGlja2VyX0luZHVzdHJ5LmNzdiIpCgpgYGAKCgoKCmBgYHtyfQpDbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lX0FsbFllYXJzIDwtIHJlYWRfY3N2KCcuLi9kYXRhL0Rlc2NlbmRpbmdfVGlja2VyX0luZHVzdHJ5X1NoYXJlUHJpY2UuY3N2JykKCkNsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWUgIDwtIENsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWVfQWxsWWVhcnMgfD4gZmlsdGVyKERheV9vZl9FYXJuaW5nc0NhbGwgPiAyMDE5LTEyLTMxKQpDbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lCmBgYAoKCmBgYHtyfQojIENsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWVfZGF0ZXMgPC0gQ2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZSB8PiBtdXRhdGUoZGF0ZV9lYXJuaW5nc2NhbGw9ZG15KGRhdGVfZWFybmluZ3NjYWxsKSkgCiMgQ2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZV9kYXRlcwoKYGBgCgoKCgpFeGFtaW5lcyBOZXQgQ09WSUQgU2VudGltZW50IGFjcm9zcyBpbmR1c3RyaWVzIG92ZXIgdGltZTogCgpTaWRlIG5vdGU6IEFkdmVydGlzaW5nIEFnZW5jaWVzIGlzIHRoZSByZWZlcmVuY2UgSW5kdXN0cnkgCgpgYGB7cn0KCmxtKGxvZyhDb3ZpZF9OZXRfU2VudGltZW50KSB+IGMoSW5kdXN0cnkpICsgRGF5X29mX0Vhcm5pbmdzQ2FsbCArIENvdmlkX0V4cG9zdXJlLCBkYXRhPUNsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWUpIHw+IAogIHN1bW1hcnkoKQoKYGBgCgoKCgoKRXhhbWluZXMgUG9zaXRpdmUgQ09WSUQgU2VudGltZW50IGFjcm9zcyBpbmR1c3RyaWVzIG92ZXIgdGltZToKCmBgYHtyfQoKbG0oQ292aWRfUG9zX1NlbnRpbWVudCB+IGMoSW5kdXN0cnkpICsgRGF5X29mX0Vhcm5pbmdzQ2FsbCArIENvdmlkX0V4cG9zdXJlLCBkYXRhPUNsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWUpIHw+IAogIHN1bW1hcnkoKQoKYGBgCgpgYGB7cn0KCmxtKENvdmlkX05lZ19TZW50aW1lbnQgfiBjKEluZHVzdHJ5KSArIERheV9vZl9FYXJuaW5nc0NhbGwgKyBDb3ZpZF9FeHBvc3VyZSArIFBSaXNrVF9oZWFsdGgsIGRhdGE9Q2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZSkgfD4gCiAgc3VtbWFyeSgpCgpgYGAgCgoKRXhhbWluZXMgTmVnYXRpdmUgQ09WSUQgU2VudGltZW50IGFjcm9zcyBpbmR1c3RyaWVzIG92ZXIgdGltZToKCmBgYHtyfQoKbG0oQ292aWRfTmVnX1NlbnRpbWVudCB+IGMoSW5kdXN0cnkpICsgRGF5X29mX0Vhcm5pbmdzQ2FsbCArIENvdmlkX0V4cG9zdXJlICsgUFJpc2tUX2hlYWx0aCwgZGF0YT1DbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lKSB8PiAKICBzdW1tYXJ5KCkKCmBgYAoKCgoKYGBge3J9CgpsbShQZXJjZW50X0NoYW5nZV9idF9EYXlCZWZvcmVfeV9EYXlBZnRlciB+IGMoSW5kdXN0cnkpICsgRGF5X29mX0Vhcm5pbmdzQ2FsbCArIENvdmlkX05ldF9TZW50aW1lbnQgKyBDb3ZpZF9OZXRfU2VudGltZW50OmMoSW5kdXN0cnkpLCBkYXRhPUNsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWUpIHw+IAogIHN1bW1hcnkoKQoKYGBgCgpgYGB7cn0KClBlcmNlbnRDaGFuZ2VfU2hhcmVQcmljZXNfSGllcmNoaWNhbEluZHVzdHJ5Q29tcGFueV9SYW5kb21JbmR1c3RyeUZpcm1zIDwtIGdsbWVyKAogICJQZXJjZW50X0NoYW5nZV9idF9EYXlCZWZvcmVfeV9EYXlBZnRlciB+IERheV9vZl9FYXJuaW5nc0NhbGwgKyBDb3ZpZF9OZXRfU2VudGltZW50ICsgKDEgfCBJbmR1c3RyeS9jb21wYW55X25hbWUpIiwgCiAgZGF0YT1DbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lLAogIGZhbWlseT1nYXVzc2lhbikgCgpQZXJjZW50Q2hhbmdlX1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnlfUmFuZG9tSW5kdXN0cnlGaXJtcyAKYGBgIAoKYGBge3J9CnN1bW1hcnkoUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55X1JhbmRvbUluZHVzdHJ5RmlybXMpJGNvZWZmaWNpZW50cyAgCmBgYApwLXZhbHVlIGZvciBEYXlfb2ZfRWFybmluZ3NDYWxsIDwgMC4wNQpwLXZhbHVlIGZvciBDb3ZpZF9OZXRfU2VudGltZW50IDwgMC4wMQoKYGBge3J9CnRpZHkoUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55X1JhbmRvbUluZHVzdHJ5RmlybXMpCmBgYAoKCmBgYHtyfQoKUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55IDwtIGdsbWVyKAogICJQZXJjZW50X0NoYW5nZV9idF9EYXlCZWZvcmVfeV9EYXlBZnRlciB+IC0xICsgRGF5X29mX0Vhcm5pbmdzQ2FsbCArIGMoSW5kdXN0cnkpICsgQ292aWRfTmV0X1NlbnRpbWVudDpjKEluZHVzdHJ5KSArICgxIHwgY29tcGFueV9uYW1lKSIsIAogIGRhdGE9Q2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZSwKICBmYW1pbHk9Z2F1c3NpYW4pIAoKc3VtbWFyeShQZXJjZW50Q2hhbmdlX1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnkpJGNvZWZmaWNpZW50cyAgCgpgYGAgCgoKYGBge3J9CgpQZXJjZW50Q2hhbmdlX05lZ0NPVklEU2VudGltZW50X1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnkgPC0gZ2xtZXIoCiAgIlBlcmNlbnRfQ2hhbmdlX2J0X0RheUJlZm9yZV95X0RheUFmdGVyIH4gLTEgKyBEYXlfb2ZfRWFybmluZ3NDYWxsICsgYyhJbmR1c3RyeSkgKyBDb3ZpZF9OZWdfU2VudGltZW50OmMoSW5kdXN0cnkpICsgKDEgfCBjb21wYW55X25hbWUpIiwgCiAgZGF0YT1DbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lLAogIGZhbWlseT1nYXVzc2lhbikgCgpzdW1tYXJ5KFBlcmNlbnRDaGFuZ2VfTmVnQ09WSURTZW50aW1lbnRfU2hhcmVQcmljZXNfSGllcmNoaWNhbEluZHVzdHJ5Q29tcGFueSkkY29lZmZpY2llbnRzICAKCmBgYCAKCiAKYGBge3J9CgpQZXJjZW50Q2hhbmdlX1Bvc0NPVklEU2VudGltZW50X1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnkgPC0gZ2xtZXIoCiAgIlBlcmNlbnRfQ2hhbmdlX2J0X0RheUJlZm9yZV95X0RheUFmdGVyIH4gLTEgKyBEYXlfb2ZfRWFybmluZ3NDYWxsICsgYyhJbmR1c3RyeSkgKyBDb3ZpZF9Qb3NfU2VudGltZW50OmMoSW5kdXN0cnkpICsgKDEgfCBjb21wYW55X25hbWUpIiwgCiAgZGF0YT1DbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lLAogIGZhbWlseT1nYXVzc2lhbikgCgpzdW1tYXJ5KFBlcmNlbnRDaGFuZ2VfUG9zQ09WSURTZW50aW1lbnRfU2hhcmVQcmljZXNfSGllcmNoaWNhbEluZHVzdHJ5Q29tcGFueSkkY29lZmZpY2llbnRzICAKCmBgYCAgCgoKCgpgYGB7cn0KCnNhdmVSRFMoUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55LCBmaWxlPSIuLi9kYXRhL01peGVkRWZmZWN0c19IaWVyYXJjaGljYWxNb2RlbC5SRFMiKQoKYGBgCgoKYGBge3J9CnN1bW1hcnkoUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55KSRjb2VmZmljaWVudHNwWyw0XSAgCmBgYAoKCgpgYGB7cn0KdGlkeShQZXJjZW50Q2hhbmdlX1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnksIGNvbmYuaW50PVRSVUUpCmBgYAoKYGBge3J9CkZpeGVkRWZmZWN0c19JbmR1c3RyeUNvZWZmaWNpZW50cyA8LSB0aWR5KFBlcmNlbnRDaGFuZ2VfU2hhcmVQcmljZXNfSGllcmNoaWNhbEluZHVzdHJ5Q29tcGFueSwgY29uZi5pbnQ9VFJVRSkgfD4gCiAgZmlsdGVyKGVmZmVjdD09ImZpeGVkIikgIAoKRml4ZWRFZmZlY3RzX0luZHVzdHJ5Q29lZmZpY2llbnRzCmBgYAoKCmBgYHtyfQpTdGF0U2lnX0luZHVzdHJpZXNfVGltZV95X0ludGVyYWN0aW9uVGVybUluZHVzdHJ5TmV0Q09WSURTZW50aW1lbnQgPC0gRml4ZWRFZmZlY3RzX0luZHVzdHJ5Q29lZmZpY2llbnRzIHw+IAogIGZpbHRlcihjb25mLmhpZ2ggPCAwIHwgY29uZi5sb3cgPiAwKSAgCgpTdGF0U2lnX0luZHVzdHJpZXNfVGltZV95X0ludGVyYWN0aW9uVGVybUluZHVzdHJ5TmV0Q09WSURTZW50aW1lbnQKYGBgCgoKCgoKCgoKYGBge3J9CnRpZHkoUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55LCBjb25mLmludD1UUlVFKSB8PiAKICBmaWx0ZXIoZWZmZWN0PT0iZml4ZWQiKSB8PiAKICBnZ3Bsb3QoYWVzKHg9cmVvcmRlcih0ZXJtLCBlc3RpbWF0ZSksIHk9ZXN0aW1hdGUpKSArCiAgZ2VvbV9wb2ludCgpICsKICBnZW9tX2Vycm9yYmFyKGFlcyh5bWluPWNvbmYubG93LCB5bWF4PWNvbmYuaGlnaCwgd2lkdGg9MC4wNSkpICsKICBsYWJzKHg9IkluZHVzdHJpZXMiKSArIAogIGxhYnMoeT0iJSBDaGFuZ2UgaW4gU2hhcmUgUHJpY2UgYXMgQSBGdW5jdGlvbiBvZiBOZXQgQ09WSUQgU2VudGltZW50IikgKwogIGNvb3JkX2ZsaXAoKSAKYGBgCmBgYHtyfQpDbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lX0Ryb3BOQSA8LSBDbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lIHw+IGRyb3BfbmEoYFBlcmNlbnRfQ2hhbmdlX2J0X0RheUJlZm9yZV95X0RheUFmdGVyYCwgYEluZHVzdHJ5YCwgYERheV9vZl9FYXJuaW5nc0NhbGxgLCBgY29tcGFueV9uYW1lYCwgYENvdmlkX05ldF9TZW50aW1lbnRgKQoKQ2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZV9Ecm9wTkEKYGBgCgoKYGBge3J9IAp0aWJibGUocmVzaWQ9cmVzaWQoUGVyY2VudENoYW5nZV9TaGFyZVByaWNlc19IaWVyY2hpY2FsSW5kdXN0cnlDb21wYW55KSwgZGF0ZT1DbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lX0Ryb3BOQSREYXlfb2ZfRWFybmluZ3NDYWxsKSB8PiAKICBmaWx0ZXIoZGF0ZSA+ICIyMDE5LTAxLTAxIikgfD4gCiAgZ2dwbG90KGFlcyh4PWRhdGUsIHk9cmVzaWQpKSArCiAgZ2VvbV9wb2ludChhbHBoYT0wLjIpICsKICBnZW9tX3Ntb290aCgpICsKICB5bGltKC0yNSwgMjUpCiMgc3RhdF9wb2x5X2VxKHVzZV9sYWJlbChjKCJlcSIsICJhZGouUjIiLCAiZiIsICJwIiwgIm4iKSksIHZzdGVwPTIyLCBzaXplPTMuOCkgCmBgYApgYGB7cn0KY0luZHVzdHJ5X1JlbW92YWwgPSBmdW5jdGlvbihsYWIpIHsKICBzdHJfcmVtb3ZlKGxhYiwgImNcXChJbmR1c3RyeVxcKSIpICAKfQoKRGF5T2ZFYXJuaW5nc0NhbGxfUmVtb3ZhbCA9IGZ1bmN0aW9uKGxhYikgewogIHN0cl9yZW1vdmUobGFiLCAiRGF5X29mX0Vhcm5pbmdzQ2FsbCIpICAKfQoKYGBgCgoKYGBge3J9ClN0YXRTaWdfSW5kdXN0cmllc19UaW1lX3lfSW50ZXJhY3Rpb25UZXJtSW5kdXN0cnlOZXRDT1ZJRFNlbnRpbWVudCA8LSBTdGF0U2lnX0luZHVzdHJpZXNfVGltZV95X0ludGVyYWN0aW9uVGVybUluZHVzdHJ5TmV0Q09WSURTZW50aW1lbnQgfD4gbXV0YXRlKHRlcm0gPSBjSW5kdXN0cnlfUmVtb3ZhbCh0ZXJtKSkgfD4gbXV0YXRlKHRlcm0gPSBEYXlPZkVhcm5pbmdzQ2FsbF9SZW1vdmFsKHRlcm0pKQoKU3RhdFNpZ19JbmR1c3RyaWVzX1RpbWVfeV9JbnRlcmFjdGlvblRlcm1JbmR1c3RyeU5ldENPVklEU2VudGltZW50CmBgYAoKCgoKYGBge3J9IAoKQmFyR3JhcGhfU3RhdFNpZ19JbmR1c3RyaWVzIDwtIGdncGxvdChkYXRhPVN0YXRTaWdfSW5kdXN0cmllc19UaW1lX3lfSW50ZXJhY3Rpb25UZXJtSW5kdXN0cnlOZXRDT1ZJRFNlbnRpbWVudCwgYWVzKHg9cmVvcmRlcih0ZXJtLCBlc3RpbWF0ZSksIHk9ZXN0aW1hdGUpKSArCiAgZ2VvbV9iYXIoc3RhdD0iaWRlbnRpdHkiLCBmaWxsPSJzdGVlbGJsdWUiKSArCiAgY29vcmRfZmxpcCgpICsKICB0aGVtZV9taW5pbWFsKCkgKwogIGxhYnMoeD0iSW5kdXN0cmllcyIpICsgCiAgbGFicyh5PSIlIENoYW5nZSBpbiBTdG9jayBQcmljZSBhcyBBIEZ1bmN0aW9uIG9mIE5ldCBDT1ZJRCBTZW50aW1lbnQiKSArIAogIGxhYnModGl0bGU9Ik5vdGFibGUgSW5kdXN0cmllcyBXaG9zZSBTaGFyZSBQcmljZXMgT3V0cGVyZm9ybWVkIiwgc3VidGl0bGU9Ik1peGVkLUVmZmVjdCBMaW5lYXIgUmVncmVzc2lvbiBBbmFseXNpcyBvZiBIb3cgUGVyY2VudGFnZSBDaGFuZ2UgaW4gU2hhcmUgUHJpY2UgQ29ycmVsYXRlcyB3aXRoIE5ldCBDT1ZJRC1SZWxhdGVkIFNlbnRpbWVudCIpCgpCYXJHcmFwaF9TdGF0U2lnX0luZHVzdHJpZXMKCmBgYAoKCgoKYGBge3J9ClN0YXRTaWdfSW5kdXN0cnlOZXRDT1ZJRFNlbnRpbWVudEludGVyYWN0aW9uIDwtIFN0YXRTaWdfSW5kdXN0cmllc19UaW1lX3lfSW50ZXJhY3Rpb25UZXJtSW5kdXN0cnlOZXRDT1ZJRFNlbnRpbWVudCB8PiBmaWx0ZXIoc3RyX2RldGVjdCh0ZXJtLCAiOkNvdmlkX05ldF9TZW50aW1lbnQiKSkKU3RhdFNpZ19JbmR1c3RyeU5ldENPVklEU2VudGltZW50SW50ZXJhY3Rpb24KYGBgCiAKYGBge3J9ClN0YXRTaWdfSW5kdXN0cmllcyA8LSBTdGF0U2lnX0luZHVzdHJpZXNfVGltZV95X0ludGVyYWN0aW9uVGVybUluZHVzdHJ5TmV0Q09WSURTZW50aW1lbnQgfD4gZmlsdGVyKCFzdHJfZGV0ZWN0KHRlcm0sICI6Q292aWRfTmV0X1NlbnRpbWVudCIpKQpTdGF0U2lnX0luZHVzdHJpZXMKYGBgIApgYGB7cn0KCkludGVyYWN0aW9uVGVybUxhYmVsX1JlbW92YWwgPSBmdW5jdGlvbihsYWIpIHsKICBzdHJfcmVtb3ZlKGxhYiwgIjpDb3ZpZF9OZXRfU2VudGltZW50IikgIAp9CgpTdGF0U2lnX0luZHVzdHJ5TmV0Q09WSURTZW50aW1lbnRJbnRlcmFjdGlvbl9UcmltbWVkTGFiZWxzIDwtIFN0YXRTaWdfSW5kdXN0cnlOZXRDT1ZJRFNlbnRpbWVudEludGVyYWN0aW9uIHw+IG11dGF0ZSh0ZXJtID0gSW50ZXJhY3Rpb25UZXJtTGFiZWxfUmVtb3ZhbCh0ZXJtKSkKCmBgYAoKCmBgYHtyfQoKQmFyR3JhcGhfU3RhdFNpZ19JbmR1c3RyeU5ldENPVklEU2VudGltZW50SW50ZXJhY3Rpb25fVHJpbW1lZExhYmVscyA8LSBnZ3Bsb3QoZGF0YT1TdGF0U2lnX0luZHVzdHJ5TmV0Q09WSURTZW50aW1lbnRJbnRlcmFjdGlvbl9UcmltbWVkTGFiZWxzLCBhZXMoeD1yZW9yZGVyKHRlcm0sIGVzdGltYXRlKSwgeT1lc3RpbWF0ZSkpICsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IiwgZmlsbD0ic3RlZWxibHVlIikgKwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY29vcmRfZmxpcCgpICsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoZW1lX21pbmltYWwoKSArCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBsYWJzKHg9IkluZHVzdHJpZXMiKSArIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbGFicyh5PSIlIENoYW5nZSBpbiBTdG9jayBQcmljZSBhcyBBIEZ1bmN0aW9uIG9mIE5ldCBDT1ZJRCBTZW50aW1lbnQiKSArIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbGFicyh0aXRsZT0iSW5kdXN0cmllcyBXaG9zZSBTdG9jayBQcmljZSBDaGFuZ2VzIERpc3Byb3BvcnRpb25hbGx5IENvcnJlbGF0ZSB3aXRoIE5ldCBDT1ZJRCBTZW50aW1lbnQiLCBzdWJ0aXRsZT0iTWl4ZWQtRWZmZWN0IExpbmVhciBSZWdyZXNzaW9uIEFuYWx5c2lzIG9mIEhvdyBQZXJjZW50YWdlIENoYW5nZSBpbiBTaGFyZSBQcmljZSBDb3JyZWxhdGVzIHdpdGggTmV0IENPVklELVJlbGF0ZWQgU2VudGltZW50IikKCkJhckdyYXBoX1N0YXRTaWdfSW5kdXN0cnlOZXRDT1ZJRFNlbnRpbWVudEludGVyYWN0aW9uX1RyaW1tZWRMYWJlbHMKCgpgYGAKCgoKCgoKYGBge3J9CgpCYXJHcmFwaF9TdGF0U2lnX0luZHVzdHJpZXMgPC0gZ2dwbG90KGRhdGE9U3RhdFNpZ19JbmR1c3RyaWVzLCBhZXMoeD1yZW9yZGVyKHRlcm0sIGVzdGltYXRlKSwgeT1lc3RpbWF0ZSkpICsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IiwgZmlsbD0ic3RlZWxibHVlIikgKwogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY29vcmRfZmxpcCgpICsKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoZW1lX21pbmltYWwoKSArCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBsYWJzKHg9IkluZHVzdHJpZXMiKSArIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbGFicyh5PSIlIENoYW5nZSBpbiBTdG9jayBQcmljZSBhcyBBIEZ1bmN0aW9uIG9mIE5ldCBDT1ZJRCBTZW50aW1lbnQiKSArIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgbGFicyh0aXRsZT0iSW5kdXN0cmllcyBXaG9zZSBTdG9jayBQcmljZSBDaGFuZ2VzIFN0YXRpc3RpY2FsbHkgU2lnbmlmaWNhbnRseSBDb3JyZWxhdGUgd2l0aCBOZXQgQ09WSUQgU2VudGltZW50Iiwgc3VidGl0bGU9Ik1peGVkLUVmZmVjdCBMaW5lYXIgUmVncmVzc2lvbiBBbmFseXNpcyBvZiBIb3cgQ2hhbmdlcyBpbiBTdG9jayBQcmljZSBDb3JyZWxhdGUgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKQmFyR3JhcGhfU3RhdFNpZ19JbmR1c3RyaWVzCgoKYGBgCgoKCgpgYGB7cn0KdGlkeShQZXJjZW50Q2hhbmdlX1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnksIGVmZmVjdHM9InJhbl92YWxzIiwgY29uZi5pbnQ9VFJVRSkgCmBgYAoKCmBgYHtyfQpSYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2MgPC0gdGlkeShQZXJjZW50Q2hhbmdlX1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnksIGVmZmVjdHM9InJhbl92YWxzIiwgY29uZi5pbnQ9VFJVRSkgfD4gYXJyYW5nZShkZXNjKGVzdGltYXRlKSkKUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjIApgYGAKCmBgYHtyfQpDb21wYW55X0luZHVzdHJ5ICA8LSBDbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lIHw+IAogIHNlbGVjdChjb21wYW55X25hbWUsIEluZHVzdHJ5KSB8PiAKICB1bmlxdWUoKQoKQ29tcGFueV9JbmR1c3RyeSAKYGBgCgoKYGBge3J9CkZpcm1fSW5kdXN0cnlfUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjIDwtIFJhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyAgfD4gCiAgaW5uZXJfam9pbihDb21wYW55X0luZHVzdHJ5LCBieT1qb2luX2J5KGxldmVsPT1jb21wYW55X25hbWUpKQoKRmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2MKYGBgCgpMZXQncyBsb29rIGF0IHN0b2NrIHBlcmZvcm1hbmNlIG9mIGZpcm1zIHdpdGhpbiBpbmR1c3RyaWVzIHdob3NlIHNoYXJlIHByaWNlIGNoYW5nZXMgd2VyZSBsZXNzIGltcGFjdGVkIGJ5IE5ldCBDT1ZJRCBTZW50aW1lbnQuCgpgYGB7cn0KR3JvY2VyeV9TdG9yZXMgPC0gZ2dwbG90KGRhdGE9RmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2MgfD4gZmlsdGVyKEluZHVzdHJ5PT0iR3JvY2VyeSBTdG9yZXMiKSwgYWVzKHg9cmVvcmRlcihsZXZlbCwgZXN0aW1hdGUpLCB5PWVzdGltYXRlKSkgKwogIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IiwgZmlsbD0ic3RlZWxibHVlIikgKwogIGNvb3JkX2ZsaXAoKSArCiAgdGhlbWVfbWluaW1hbCgpICsKICBsYWJzKHg9IkNvbXBhbmllcyIpICsgCiAgbGFicyh5PSJBZGRpdGlvbmFsICUgb2YgQ29ycmVsYXRpdmUgQ2hhbmdlIGluIFN0b2NrIFByaWNlIGZyb20gSW5kdXN0cnkgQXZlcmFnZSIpICsgCiAgbGFicyh0aXRsZT0iQ2hhbmdlcyBpbiBTdG9jayBQcmljZXMgb2YgR3JvY2VyeSBTdG9yZXMgd2l0aCBSZXNwZWN0IHRvIEluZHVzdHJ5Iiwgc3VidGl0bGU9Ik1peGVkLUVmZmVjdCBMaW5lYXIgUmVncmVzc2lvbiBBbmFseXNpcyBvZiBIb3cgUGVyY2VudGFnZSBDaGFuZ2UgaW4gU2hhcmUgUHJpY2UgQ29ycmVsYXRlcyB3aXRoIE5ldCBDT1ZJRC1SZWxhdGVkIFNlbnRpbWVudCIpCgpHcm9jZXJ5X1N0b3JlcwpgYGAKCgoKYGBge3J9CkF1dG9fbl9UcnVja19EZWFsZXJzaGlwcyA8LSBnZ3Bsb3QoZGF0YT1GaXJtX0luZHVzdHJ5X1JhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyB8PiBmaWx0ZXIoSW5kdXN0cnk9PSJBdXRvICYgVHJ1Y2sgRGVhbGVyc2hpcHMiKSwgYWVzKHg9cmVvcmRlcihsZXZlbCwgZXN0aW1hdGUpLCB5PWVzdGltYXRlKSkgKwogIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IiwgZmlsbD0ic3RlZWxibHVlIikgKwogIGNvb3JkX2ZsaXAoKSArCiAgdGhlbWVfbWluaW1hbCgpICsKICBsYWJzKHg9IkNvbXBhbmllcyIpICsgCiAgbGFicyh5PSJBZGRpdGlvbmFsICUgb2YgQ29ycmVsYXRpdmUgQ2hhbmdlIGluIFN0b2NrIFByaWNlIGZyb20gSW5kdXN0cnkgQXZlcmFnZSIpICsgCiAgbGFicyh0aXRsZT0iQ2hhbmdlcyBpbiBTdG9jayBQcmljZXMgb2YgQXV0by9UcnVjayBEZWFsZXJzaGlwIEZpcm1zIHdpdGggUmVzcGVjdCB0byBJbmR1c3RyeSIsIHN1YnRpdGxlPSJNaXhlZC1FZmZlY3QgTGluZWFyIFJlZ3Jlc3Npb24gQW5hbHlzaXMgb2YgSG93IFBlcmNlbnRhZ2UgQ2hhbmdlIGluIFNoYXJlIFByaWNlIENvcnJlbGF0ZXMgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKQXV0b19uX1RydWNrX0RlYWxlcnNoaXBzCmBgYAoKYGBge3J9CkluZHVzdHJpYWxfRGlzdHJpYnV0aW9uIDwtIGdncGxvdChkYXRhPUZpcm1fSW5kdXN0cnlfUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjIHw+IGZpbHRlcihJbmR1c3RyeT09IkluZHVzdHJpYWwgRGlzdHJpYnV0aW9uIiksIGFlcyh4PXJlb3JkZXIobGV2ZWwsIGVzdGltYXRlKSwgeT1lc3RpbWF0ZSkpICsKICBnZW9tX2JhcihzdGF0PSJpZGVudGl0eSIsIGZpbGw9InN0ZWVsYmx1ZSIpICsKICBjb29yZF9mbGlwKCkgKwogIHRoZW1lX21pbmltYWwoKSArCiAgbGFicyh4PSJDb21wYW5pZXMiKSArIAogIGxhYnMoeT0iQWRkaXRpb25hbCAlIG9mIENvcnJlbGF0aXZlIENoYW5nZSBpbiBTdG9jayBQcmljZSBmcm9tIEluZHVzdHJ5IEF2ZXJhZ2UiKSArIAogIGxhYnModGl0bGU9IkNoYW5nZXMgaW4gU3RvY2sgUHJpY2VzIG9mIEluZHVzdHJpYWwgRGlzdHJpYnV0aW9uIEZpcm1zIHdpdGggUmVzcGVjdCB0byBJbmR1c3RyeSIsIHN1YnRpdGxlPSJNaXhlZC1FZmZlY3QgTGluZWFyIFJlZ3Jlc3Npb24gQW5hbHlzaXMgb2YgSG93IFBlcmNlbnRhZ2UgQ2hhbmdlIGluIFNoYXJlIFByaWNlIENvcnJlbGF0ZXMgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKSW5kdXN0cmlhbF9EaXN0cmlidXRpb24KYGBgCgoKVGhlbiwgbGV0J3MgbG9vayBhdCBzdG9jayBwZXJmb3JtYW5jZSBvZiBmaXJtcyB3aXRoaW4gaW5kdXN0cmllcyB3aG9zZSBzaGFyZSBwcmljZSBjaGFuZ2VzIHdlcmUgbW9yZSBpbXBhY3RlZCBieSBOZXQgQ09WSUQgU2VudGltZW50LgoKCgpgYGB7cn0KRGlzY291bnRfU3RvcmVzIDwtIGdncGxvdChkYXRhPUZpcm1fSW5kdXN0cnlfUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjIHw+IGZpbHRlcihJbmR1c3RyeT09IkRpc2NvdW50IFN0b3JlcyIpLCBhZXMoeD1yZW9yZGVyKGxldmVsLCBlc3RpbWF0ZSksIHk9ZXN0aW1hdGUpKSArCiAgZ2VvbV9iYXIoc3RhdD0iaWRlbnRpdHkiLCBmaWxsPSJzdGVlbGJsdWUiKSArCiAgY29vcmRfZmxpcCgpICsKICB0aGVtZV9taW5pbWFsKCkgKwogIGxhYnMoeD0iQ29tcGFuaWVzIikgKyAKICBsYWJzKHk9IkFkZGl0aW9uYWwgJSBvZiBDb3JyZWxhdGl2ZSBDaGFuZ2UgaW4gU3RvY2sgUHJpY2UgZnJvbSBJbmR1c3RyeSBBdmVyYWdlIikgKyAKICBsYWJzKHRpdGxlPSJDaGFuZ2VzIGluIFN0b2NrIFByaWNlcyBvZiBEaXNjb3VudCBTdG9yZXMgd2l0aCBSZXNwZWN0IHRvIEluZHVzdHJ5Iiwgc3VidGl0bGU9Ik1peGVkLUVmZmVjdCBMaW5lYXIgUmVncmVzc2lvbiBBbmFseXNpcyBvZiBIb3cgUGVyY2VudGFnZSBDaGFuZ2UgaW4gU2hhcmUgUHJpY2UgQ29ycmVsYXRlcyB3aXRoIE5ldCBDT1ZJRC1SZWxhdGVkIFNlbnRpbWVudCIpCgpEaXNjb3VudF9TdG9yZXMKYGBgCgoKYGBge3J9CkNvbnN1bWVyX0VsZWN0cm9uaWNzIDwtIGdncGxvdChkYXRhPUZpcm1fSW5kdXN0cnlfUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjIHw+IGZpbHRlcihJbmR1c3RyeT09IkNvbnN1bWVyIEVsZWN0cm9uaWNzIiksIGFlcyh4PXJlb3JkZXIobGV2ZWwsIGVzdGltYXRlKSwgeT1lc3RpbWF0ZSkpICsKICBnZW9tX2JhcihzdGF0PSJpZGVudGl0eSIsIGZpbGw9InN0ZWVsYmx1ZSIpICsKICBjb29yZF9mbGlwKCkgKwogIHRoZW1lX21pbmltYWwoKSArCiAgbGFicyh4PSJDb21wYW5pZXMiKSArIAogIGxhYnMoeT0iQWRkaXRpb25hbCAlIG9mIENvcnJlbGF0aXZlIENoYW5nZSBpbiBTdG9jayBQcmljZSBmcm9tIEluZHVzdHJ5IEF2ZXJhZ2UiKSArIAogIGxhYnModGl0bGU9IkNoYW5nZXMgaW4gU3RvY2sgUHJpY2VzIG9mIENvbnN1bWVyIEVsZWN0cm9uaWNzIEZpcm1zIHdpdGggUmVzcGVjdCB0byBJbmR1c3RyeSIsIHN1YnRpdGxlPSJNaXhlZC1FZmZlY3QgTGluZWFyIFJlZ3Jlc3Npb24gQW5hbHlzaXMgb2YgSG93IFBlcmNlbnRhZ2UgQ2hhbmdlIGluIFNoYXJlIFByaWNlIENvcnJlbGF0ZXMgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKQ29uc3VtZXJfRWxlY3Ryb25pY3MgCmBgYAoKYGBge3J9CkludGVncmF0ZWRfRnJlaWdodF9uX0xvZ2lzdGljcyA8LSBnZ3Bsb3QoZGF0YT1GaXJtX0luZHVzdHJ5X1JhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyB8PiBmaWx0ZXIoSW5kdXN0cnk9PSJJbnRlZ3JhdGVkIEZyZWlnaHQgJiBMb2dpc3RpY3MiKSwgYWVzKHg9cmVvcmRlcihsZXZlbCwgZXN0aW1hdGUpLCB5PWVzdGltYXRlKSkgKwogIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IiwgZmlsbD0ic3RlZWxibHVlIikgKwogIGNvb3JkX2ZsaXAoKSArCiAgdGhlbWVfbWluaW1hbCgpICsKICBsYWJzKHg9IkNvbXBhbmllcyIpICsgCiAgbGFicyh5PSJBZGRpdGlvbmFsICUgb2YgQ29ycmVsYXRpdmUgQ2hhbmdlIGluIFN0b2NrIFByaWNlIGZyb20gSW5kdXN0cnkgQXZlcmFnZSIpICsgCiAgbGFicyh0aXRsZT0iQ2hhbmdlcyBpbiBTdG9jayBQcmljZXMgb2YgSW50ZWdyYXRlZCBGcmVpZ2h0ICYgTG9naXN0aWNzIEZpcm1zIHdpdGggUmVzcGVjdCB0byBJbmR1c3RyeSIsIHN1YnRpdGxlPSJNaXhlZC1FZmZlY3QgTGluZWFyIFJlZ3Jlc3Npb24gQW5hbHlzaXMgb2YgSG93IFBlcmNlbnRhZ2UgQ2hhbmdlIGluIFNoYXJlIFByaWNlIENvcnJlbGF0ZXMgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKSW50ZWdyYXRlZF9GcmVpZ2h0X25fTG9naXN0aWNzCmBgYAoKCgpOZXh0LCBsZXQncyBsb29rIGludG8gbm90YWJsZSBpbmR1c3RyaWVzIHdob3NlIHNoYXJlIHByaWNlcyBvdXRwZXJmb3JtZWQgdGhvc2UgaW4gb3RoZXIgaW5kdXN0cmllczoKCgoKYGBge3J9CkVsZWN0cm9uaWNfR2FtaW5nX25fTXVsdGltZWRpYSA8LSBnZ3Bsb3QoZGF0YT1GaXJtX0luZHVzdHJ5X1JhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyB8PiBmaWx0ZXIoSW5kdXN0cnk9PSJFbGVjdHJvbmljIEdhbWluZyAmIE11bHRpbWVkaWEiKSwgYWVzKHg9cmVvcmRlcihsZXZlbCwgZXN0aW1hdGUpLCB5PWVzdGltYXRlKSkgKwogIGdlb21fYmFyKHN0YXQ9ImlkZW50aXR5IiwgZmlsbD0ic3RlZWxibHVlIikgKwogIGNvb3JkX2ZsaXAoKSArCiAgdGhlbWVfbWluaW1hbCgpICsKICBsYWJzKHg9IkNvbXBhbmllcyIpICsgCiAgbGFicyh5PSJBZGRpdGlvbmFsICUgb2YgQ29ycmVsYXRpdmUgQ2hhbmdlIGluIFN0b2NrIFByaWNlIGZyb20gSW5kdXN0cnkgQXZlcmFnZSIpICsgCiAgbGFicyh0aXRsZT0iQ2hhbmdlcyBpbiBTdG9jayBQcmljZXMgb2YgRWxlY3Ryb25pYyBHYW1pbmcgJiBNdWx0aW1lZGlhIEZpcm1zIHdpdGggUmVzcGVjdCB0byBJbmR1c3RyeSIsIHN1YnRpdGxlPSJNaXhlZC1FZmZlY3QgTGluZWFyIFJlZ3Jlc3Npb24gQW5hbHlzaXMgb2YgSG93IFBlcmNlbnRhZ2UgQ2hhbmdlIGluIFNoYXJlIFByaWNlIENvcnJlbGF0ZXMgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKRWxlY3Ryb25pY19HYW1pbmdfbl9NdWx0aW1lZGlhCmBgYAoKCgoKYGBge3J9ClRvcEZpcm1zIDwtIFJhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyB8PiAKICBmaWx0ZXIoY29uZi5sb3cgPiAwKQpUb3BGaXJtcwpgYGAKCmBgYHtyfQpCb3R0b21GaXJtcyA8LSBSYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2MgfD4gCiAgZmlsdGVyKGNvbmYuaGlnaCA8IDApCkJvdHRvbUZpcm1zIApgYGAKCgpgYGB7cn0KU3RhdFNpZ19GaXJtcyA8LSBSYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2MgfD4gCiAgZmlsdGVyKGNvbmYuaGlnaCA8IDAgfCBjb25mLmxvdyA+IDApClN0YXRTaWdfRmlybXMgCmBgYAoKCmBgYHtyfQpUb3AyMEZpcm1zIDwtIFJhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyB8PiBoZWFkKDIwKSAKVG9wMjBGaXJtcwpgYGAKCgpBZGQgYSBib29sZWFuIHN0YXRpc3RpY2FsIHNpZ25pZmljYW5jZSBjb2x1bW46CgpgYGB7cn0KCkZpcm1fSW5kdXN0cnlfUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjX1N0YXRTaWcgPC0gUmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjICB8PiAKICBpbm5lcl9qb2luKENvbXBhbnlfSW5kdXN0cnksIGJ5PWpvaW5fYnkobGV2ZWw9PWNvbXBhbnlfbmFtZSkpIHw+IAogIHNlbGVjdChsZXZlbCwgZXN0aW1hdGUsIGNvbmYubG93LCBjb25mLmhpZ2gsIEluZHVzdHJ5KSB8PiAKICBmaWx0ZXIoY29uZi5oaWdoIDwgMCB8IGNvbmYubG93ID4gMCkgfD4gCiAgbXV0YXRlKGBTdGF0aXN0aWNhbGx5IFNpZ25pZmljYW50P2A9IlllcyIpCgpGaXJtX0luZHVzdHJ5X1JhbmRvbV9FZmZlY3RfQ29lZmZfRGVzY19TdGF0U2lnCmBgYAoKCmBgYHtyfQoKRmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2NfU3RhdEluc2lnIDwtIFJhbmRvbV9FZmZlY3RfQ29lZmZfRGVzYyAgfD4gCiAgaW5uZXJfam9pbihDb21wYW55X0luZHVzdHJ5LCBieT1qb2luX2J5KGxldmVsPT1jb21wYW55X25hbWUpKSB8PiAKICBzZWxlY3QobGV2ZWwsIGVzdGltYXRlLCBjb25mLmxvdywgY29uZi5oaWdoLCBJbmR1c3RyeSkgfD4gCiAgZmlsdGVyKGNvbmYuaGlnaCA+IDAgJiBjb25mLmxvdyA8IDApIHw+IAogIG11dGF0ZShgU3RhdGlzdGljYWxseSBTaWduaWZpY2FudD9gPSJObyIpCgpGaXJtX0luZHVzdHJ5X1JhbmRvbV9FZmZlY3RfQ29lZmZfRGVzY19TdGF0SW5zaWcKYGBgCgoKUGllY2luZyB0aGUgZmlybXMgd2hvc2Ugc3RhdHMgYXJlIHN0YXRpc3RpY2FsbHkgc2lnbmlmaWNhbnQgYmFjayB0b2dldGhlciB3aXRoIHRob3NlIHdob3NlIHN0YXRzIGFyZW4ndDoKCgpgYGB7cn0KRmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2NfU3RhdFNpZ195X1N0YXRJbnNpZyA8LSBiaW5kX3Jvd3MoRmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2NfU3RhdFNpZywgRmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2NfU3RhdEluc2lnKQoKRmlybV9JbmR1c3RyeV9SYW5kb21fRWZmZWN0X0NvZWZmX0Rlc2NfU3RhdFNpZ195X1N0YXRJbnNpZwpgYGAKCgoKCmBgYHtyfSAKQmFyR3JhcGhfQWxsRmlybXMgPC0gZ2dwbG90KGRhdGE9UmFuZG9tX0VmZmVjdF9Db2VmZl9EZXNjLCBhZXMoeD1yZW9yZGVyKGxldmVsLCBlc3RpbWF0ZSksIHk9ZXN0aW1hdGUpKSArCiAgZ2VvbV9iYXIoc3RhdD0iaWRlbnRpdHkiLCBmaWxsPSJzdGVlbGJsdWUiKSArCiAgY29vcmRfZmxpcCgpICsKICB0aGVtZV9taW5pbWFsKCkgKwogIGxhYnMoeD0iQ29tcGFuaWVzIikgKyAKICBsYWJzKHk9IiUgb2YgQWRkaXRpb25hbCBDb3JyZWxhdGl2ZSBDaGFuZ2UgaW4gU3RvY2sgUHJpY2UgZnJvbSBJbmR1c3RyeSBBdmVyYWdlIikgKyAKICBsYWJzKHRpdGxlPSJTdGVsbGFyIENvbXBhbmllcyBXaG9zZSBTaGFyZSBQcmljZXMgT3V0cGVyZm9ybWVkIFRob3NlIGluIFRoZWlyIFJlc3BlY3RpdmUgSW5kdXN0cmllcyIsIHN1YnRpdGxlPSJNaXhlZC1FZmZlY3QgTGluZWFyIFJlZ3Jlc3Npb24gQW5hbHlzaXMgb2YgSG93IFBlcmNlbnRhZ2UgQ2hhbmdlIGluIFNoYXJlIFByaWNlIENvcnJlbGF0ZXMgd2l0aCBOZXQgQ09WSUQtUmVsYXRlZCBTZW50aW1lbnQiKQoKQmFyR3JhcGhfQWxsRmlybXMgCmBgYAoKCmBgYHtyfQpCYXJHcmFwaF9TdGF0U2lnX0Zpcm1zIDwtIGdncGxvdChkYXRhPVN0YXRTaWdfRmlybXMsIGFlcyh4PXJlb3JkZXIobGV2ZWwsIGVzdGltYXRlKSwgeT1lc3RpbWF0ZSkpICsKICBnZW9tX2JhcihzdGF0PSJpZGVudGl0eSIsIGZpbGw9InN0ZWVsYmx1ZSIpICsKICBjb29yZF9mbGlwKCkgKwogIHRoZW1lX21pbmltYWwoKSArCiAgbGFicyh4PSJDb21wYW5pZXMiKSArIAogIGxhYnMoeT0iQWRkaXRpb25hbCAlIG9mIENvcnJlbGF0aXZlIENoYW5nZSBpbiBTdG9jayBQcmljZSBmcm9tIEluZHVzdHJpYWwgQXZlcmFnZSIpICsgCiAgbGFicyh0aXRsZT0iTm90YWJsZSBDb21wYW5pZXMgV2hvc2UgQ29ycmVsYXRpb25hbCBQZXJmb3JtYW5jZSBFeGNlZWRlZCBUaGVpciBSZXNwZWN0aXZlIEluZHVzdHJ5Iiwgc3VidGl0bGU9Ik1peGVkLUVmZmVjdCBMaW5lYXIgUmVncmVzc2lvbiBBbmFseXNpcyBvZiBIb3cgUGVyY2VudGFnZSBDaGFuZ2UgaW4gU2hhcmUgUHJpY2UgQ29ycmVsYXRlcyB3aXRoIE5ldCBDT1ZJRC1SZWxhdGVkIFNlbnRpbWVudCIpCgpCYXJHcmFwaF9TdGF0U2lnX0Zpcm1zCmBgYApgYGB7cn0Kc2VsZWN0X2NvbXBhbnk9YygiQ2FybWF4IEluYyIpCgpDbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lX0Ryb3BOQV9oaWdobGlnaHQgPC0gQ2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZV9Ecm9wTkEgfD4gCiAgbXV0YXRlKGhpZ2hsaWdodD1jYXNlX3doZW4oY29tcGFueV9uYW1lICVpbiUgc2VsZWN0X2NvbXBhbnkgfiBUUlVFLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgLmRlZmF1bHQ9RkFMU0UpKQpgYGAKCgpgYGB7cn0KCkNsb3NpbmdfU2hhcmVfUHJpY2VfQWNyb3NzX1RpbWVfRHJvcE5BX2hpZ2hsaWdodCB8PiAKICBmaWx0ZXIoSW5kdXN0cnk9PShJbmR1c3RyeVsoQ2xvc2luZ19TaGFyZV9QcmljZV9BY3Jvc3NfVGltZV9Ecm9wTkFfaGlnaGxpZ2h0JGNvbXBhbnlfbmFtZT09IkxvdmVzYWMgQ28iKV0gfD4gdW5pcXVlKCkpKSB8PiAKICBnZ3Bsb3QoYWVzKHg9RGF5X29mX0Vhcm5pbmdzQ2FsbCwgeT1QZXJjZW50X0NoYW5nZV9idF9EYXlCZWZvcmVfeV9EYXlBZnRlcikpICsKICBnZW9tX3BvaW50KGFlcyhzaXplPUNvdmlkX05ldF9TZW50aW1lbnQsIGNvbG9yPWhpZ2hsaWdodCksIGFscGhhPTAuNywgc2hvdy5sZWdlbmQ9RkFMU0UpICsKICBnZW9tX3Ntb290aChtZXRob2Q9bG0sIGZvcm11bGE9eSB+IHgpICsgCiAgc2NhbGVfY29sb3JfbWFudWFsKHZhbHVlcz1jKCJvcmFuZ2UiLCAiYmxhY2siKSkgKwogICMgc2NhbGVfc2l6ZV9tYW51YWwodmFsdWVzPWMoMSwgMykpICsKICAjIGdlb21fbGFiZWxfcmVwZWwoZGF0YT1DbG9zaW5nX1NoYXJlX1ByaWNlX0Fjcm9zc19UaW1lX0Ryb3BOQV9oaWdobGlnaHQgfD4gZmlsdGVyKGhpZ2hsaWdodD09VFJVRSksIGFlcyhsYWJlbD1jb21wYW55X25hbWUpKSArCiAgc3RhdF9wb2x5X2VxKHVzZV9sYWJlbChjKCJlcSIsICJhZGouUjIiLCAiZiIsICJwIiwgIm4iKSksIHZzdGVwPTIyLCBzaXplPTMuOCkgCgpgYGAKCgoKYGBge3J9CiMgdmNvdihQZXJjZW50Q2hhbmdlX1NoYXJlUHJpY2VzX0hpZXJjaGljYWxJbmR1c3RyeUNvbXBhbnkpCmBgYAoKCgoKCgoKCgoKCgoKCgoKCgoK